Formating Large number as date
You could use a helper column with a formula like:
=--TEXT(A1,"0000-00-00 00\:00\:00")
and give the column a numberformat of:
mmmm dd, yyyy hh:mm:ss
or
yyyy/mm/dd hh:mm:ss
BDT wrote:
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.
--
Dave Peterson
|