View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BDT BDT is offline
external usenet poster
 
Posts: 13
Default 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.