Thread: Format date in a cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default Format date in a cell
Agreed, only a mere hundred years out :)

"David Biddulph" wrote:

Mike H wrote:

Dates in Excel are numbers and the number 101408 is August 22 2077 ...

2177 , not 2077 ?

...so
Excel is doing exactly what your telling it to do. Without resorting
to VB I don't know of any way to make it recognise that number as the
date you believe it is. ...

Data/ Text to Columns, Mike.
--
David Biddulph



Reply With QuoteReply With Quote