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.
|