| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date conversion
I'm sure this question has been asked before.
How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion
If your data is in A1, try
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) then format the cell as d/m/yyyy "Tom" wrote: I'm sure this question has been asked before. How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion
Thank you JMB.
"JMB" wrote in message ... If your data is in A1, try =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) then format the cell as d/m/yyyy "Tom" wrote: I'm sure this question has been asked before. How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion
Hi Tom
One way Click on cell(s), DataText to ColumnsNextNextDateYMDFinish -- Regards Roger Govier "Tom" wrote in message u... I'm sure this question has been asked before. How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion
Another way:
=TEXT(A1,"0000-00-00")+0 Richard Tom wrote: I'm sure this question has been asked before. How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion
Wow! Didn't know there are many other ways. However, which of your
suggestions also work the other way around, i.e. change 15/12/2006 back to the number 20061215? "Tom" wrote in message u... I'm sure this question has been asked before. How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion
You could use a formula in another cell:
=text(a1,"yyyymmdd") If you wanted to keep it a date, just change the way it looks, you could give it a custom format of: yyyymmdd Tom wrote: Wow! Didn't know there are many other ways. However, which of your suggestions also work the other way around, i.e. change 15/12/2006 back to the number 20061215? "Tom" wrote in message u... I'm sure this question has been asked before. How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date conversion
A clever formula. Thanks again, Dave.
"Dave Peterson" wrote in message ... You could use a formula in another cell: =text(a1,"yyyymmdd") If you wanted to keep it a date, just change the way it looks, you could give it a custom format of: yyyymmdd Tom wrote: Wow! Didn't know there are many other ways. However, which of your suggestions also work the other way around, i.e. change 15/12/2006 back to the number 20061215? "Tom" wrote in message u... I'm sure this question has been asked before. How to convert the date expressed as "20061215" to read as 15/12/2006? Thanks for your help. Tom -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| Date Conversion | Excel Worksheet Functions | |||
| date conversion after pasting | Excel Worksheet Functions | |||
| Date Conversion | Excel Discussion (Misc queries) | |||
| unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Linear Mode
