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

This =TIME(A1/100,MOD(A1,100),0)
gives 2:11 PM
when A1 has value 1411

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jimbob" wrote in
message ...

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

One more...

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

And format it as time.

jimbob wrote:

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

--

Dave Peterson