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?