CSV Value to Time

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a file that is produced in Excel.csv format

One of the columns produces a time value 10:30:33

I would like to use this value as "time" however, Excel will only recognise
this as "text"

I have tried changing the format of the CELL without any success, it
continues to see it as a text value

Is there any way that I can have excel accept these values as time without
having to type them in again

Any suggestions would be greatly appreciated

TIA

Michael
 
Michael

Enter a 1 in a blank cell. Copy it. Select the 'times' Edit>Paste
Special...Values+Multiply. Now reformat as time

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top