Add leading 0 to csv import text/time H:MM

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I did alot of searching but did not find this one exactly:

I am importing a csv file into excel as text.
The column in question is a time value formated like this, 8:30
The value needs to look like this, 08:30 for a whole column.
Any way to do this?
Thanks
Mic
 
If the file retains its csv extension, by default excel will treat the data
as time, not as text. If the file has been renamed to txt, the text import
wizard allows you to specify the format of each column on import.

In either case, if it is treated as time but not formatted as you want it,
Format/ Cells/ will allow you to specify hh:mm
 
Unfortunatly, HH:MM will not work since a 24 hour clock would not work in
this instance:
I would like to add the leading 0, but not to have 08:30 pm not equal= to
20:30.
 
hh:mm AM/PM
--
David Biddulph

Mic said:
Unfortunatly, HH:MM will not work since a 24 hour clock would not work in
this instance:
I would like to add the leading 0, but not to have 08:30 pm not equal= to
20:30.
Click to expand...
 
Back
Top