Thread
:
Convert date format from 20060801 to 1st Aug 2006 (or similar)?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Toppers
external usenet poster
Posts: 4,339
Convert date format from 20060801 to 1st Aug 2006 (or similar)?
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 Quote
Toppers
View Public Profile
Find all posts by Toppers