Thread: [Solved] Text auto formatted as date format
View Single Post
 
Old 08-20-2013, 10:18 PM
Aikeedoh Aikeedoh is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Aug 2013
Posts: 2
Aikeedoh is on a distinguished road
Default Text auto formatted as date format
Hi,

I am working on an Excel table with data looking like this 100:03:00. I select the cell and it shows cell's value as 1/4/1900 4:03:00 AM.

I want the cell value to be shown as 100:03:00 as I will be using vlookup function to look for these in another table.

Thanks.
Reply With Quote