| 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) | |||
Threaded Mode
