simple time format question

newmember · May 13th, 2002, 02:13 PM

I imported a text file and excel displays the hh:mm:ss time as a floating point number. How do I fix this? I have tried formatting the cells as a Time value in the hh:mm:ss format. When I click on the cell, the edit bar at the top shows the correct time, but the cell shows the internal time format.

Thanks!

[ This Message was edited by: newmember on 2002-05-13 13:36 ]

Dexter · May 13th, 2002, 03:10 PM

Though I'm not sure of your problem, text files freqently need some data tune-up. Try highlighting the column containing the floating point number. Then, from the DATA menu, select TEXT TO COLUMNS. Just click FINISH. Does that help?

Mark W. · May 13th, 2002, 03:17 PM

I'm guessing that you somehow toggled the display formulas option. Press Control+` [on the tilde (~) key].

[ This Message was edited by: Mark W. on 2002-05-13 14:18 ]

newmember · May 13th, 2002, 03:22 PM

Sir Mark,

you are correct. [Ctrl+`] toggled the "problems" back and forth. I must find more info on this Ctrl+` stuff.

Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 02:13 PM	#1
newmember New Member Join Date: May 2002 Posts: 8	I imported a text file and excel displays the hh:mm:ss time as a floating point number. How do I fix this? I have tried formatting the cells as a Time value in the hh:mm:ss format. When I click on the cell, the edit bar at the top shows the correct time, but the cell shows the internal time format. Thanks! [ This Message was edited by: newmember on 2002-05-13 13:36 ]

May 13th, 2002, 03:10 PM	#2
Dexter Board Regular Join Date: Apr 2002 Location: St. Louis Posts: 71	Though I'm not sure of your problem, text files freqently need some data tune-up. Try highlighting the column containing the floating point number. Then, from the DATA menu, select TEXT TO COLUMNS. Just click FINISH. Does that help?

May 13th, 2002, 03:17 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	I'm guessing that you somehow toggled the display formulas option. Press Control+` [on the tilde (~) key]. [ This Message was edited by: Mark W. on 2002-05-13 14:18 ]

May 13th, 2002, 03:22 PM	#4
newmember New Member Join Date: May 2002 Posts: 8	Sir Mark, you are correct. [Ctrl+`] toggled the "problems" back and forth. I must find more info on this Ctrl+` stuff. Thanks