| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
| Changing date format in a footer | Excel Discussion (Misc queries) | |||
| DATE Format | Excel Worksheet Functions | |||
| Date Calculations | Excel Worksheet Functions | |||
| Date Format Question | Excel Discussion (Misc queries) | |||
Linear Mode
