Convert date format from 20060801 to 1st Aug 2006 (or similar)?
 

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

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?

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?

Convert date format from 20060801 to 1st Aug 2006 (or similar)
 

Thank you for the feedback.

Much of my own knowledge has been gleaned from the Excel Newsgroups so i
commend them both as a user (there's much I don't know!) and a contributor.

"excel_irate" wrote:

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?

Convert date format from 20060801 to 1st Aug 2006 (or similar)?
 

DataText to ColumnsNextNextColumn Data FormatDateYMD or YDM and Finish.


Gord Dibben MS Excel MVP

On Tue, 5 Sep 2006 02:54:02 -0700, excel_irate
wrote:

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

Convert date format from 20060801 to 1st Aug 2006 (or similar)
 

See one more answer to your posting.

Maybe save even more time and effort.

No formulas to clean up.


Gord Dibben MS Excel MVP

On Tue, 5 Sep 2006 03:17:01 -0700, excel_irate
wrote:

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?