Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert a colon into a column of existing numbers
I have two columns of numbers which are suppose to represent times, but were
entered as a number format. Example: "1845" instead of 18:45. I'm looking for a way to insert the colon into the numbers so I can do a time calculation. Note: formating the columns as Time does not work because of the way Excel handles date & time in a serial manner. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to insert dashes in a column of numbers | New Users to Excel | |||
Need to pad with Zeros to the existing list of numbers in a column | New Users to Excel | |||
Insert colon in text in cell | Excel Discussion (Misc queries) | |||
How to add a 1 to existing column of phone numbers? | Excel Discussion (Misc queries) | |||
How do I insert hypens in existing column representing social sec. | Excel Discussion (Misc queries) |