Time Format

J

jimbob

I'm importing data (ASCII format) into Excel. There is a col for tim
with values like 1411 for 2:11 and so on. When I try to format this co
for "Time" it changes all the values to "0:00". Any Ideas how I ca
correct this so that it will format correctly (i.e 1411 to 14:11 o
2:11) Thanks
 
D

Dave Peterson

One more...

Add a helper column of formulas like:
=--(TEXT(A1,"00\:00"))

And format it as time.
 
Top