| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formating Large number as date
I have columns of numbers that represent date/time info. For instance I have
the number 20081029092245 which represents: 2008/10/29 09:22:45 or October 29, 2008 at 9:22 AM And I want it to display as one of the above formats. I can parse the big number and concatenate the resulting columns, but is there a less cumbersome way to do this with Format/Cells/Number/Custom or something similar? Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| splitting and formating a number series into date/time | Excel Worksheet Functions | |||
| Sorting a large list by date (month number) | Excel Discussion (Misc queries) | |||
| large number in cell | Excel Discussion (Misc queries) | |||
| Entering Large Number | Excel Discussion (Misc queries) | |||
| dissect large number | Excel Discussion (Misc queries) | |||
Threaded Mode
