Thread: [Solved] Text auto formatted as date format
View Single Post
 
Old 08-21-2013, 09:46 AM
Aikeedoh Aikeedoh is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Aug 2013
Posts: 2
Aikeedoh is on a distinguished road
Default
Bob,

Sorry for not being clearer. Yes, the cell is displaying "100:03:00", but when I do a VLOOKUP from another sheet, the returned value is not "100:03:00", but instead it is returning a different value "4.16875". What can I do to have the returned value displayed as "100:03:00"?

Thanks
Reply With Quote