Thread: Convert date format from 20060801 to 1st Aug 2006 (or similar)?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
excel_irate excel_irate is offline
external usenet poster
  
Posts: 1
Default Convert date format from 20060801 to 1st Aug 2006 (or similar)
Thats perfect thank you, thank you. That will help me with loads of stuff.
And so quick too! Just found this community page and I'm impressed.....

"Toppers" wrote:

Try:

=TEXT(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),"dd mmmm yyyy")

"excel_irate" wrote:

Does anybody know how to convert this (20060801) to a more user friendly
output?
Reply With QuoteReply With Quote