Thread: Date conversion
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RichardSchollar RichardSchollar is offline
external usenet poster
  
Posts: 196
Default Date conversion
Another way:

=TEXT(A1,"0000-00-00")+0

Richard


Tom wrote:
I'm sure this question has been asked before.
How to convert the date expressed as "20061215" to read as 15/12/2006?
Thanks for your help.

Tom

Reply With QuoteReply With Quote