E
excel_irate
Does anybody know how to convert this (20060801) to a more user friendly
output?
output?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Convert date format from 20060801 to 1st Aug 2006 (or similar)?
T
Toppers
Try:
=TEXT(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),"dd mmmm yyyy")
=TEXT(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),"dd mmmm yyyy")
E
excel_irate
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.....
And so quick too! Just found this community page and I'm impressed.....
T
Toppers
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.
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.
G
Gord Dibben
Data>Text to Columns>Next>Next>Column Data Format>Date>YMD or YDM and Finish.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
G
Gord Dibben
See one more answer to your posting.
Maybe save even more time and effort.
No formulas to clean up.
Gord Dibben MS Excel MVP
Maybe save even more time and effort.
No formulas to clean up.
Gord Dibben MS Excel MVP