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


--
jimbob
------------------------------------------------------------------------
jimbob's Profile: http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=523723