| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changine text into a date
I have the following date 20081128
How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
=DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(R IGHT(A1,2)))
and custom format the cell to: dd/mm/yyyy -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Crauwf" wrote: I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
-- Kind regards, Niek Otten Microsoft MVP - Excel "Crauwf" wrote in message ... I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
Select the range of cells to be converted
Use Data | Text to Columns Use Delimits, click Next until you get to step 3 Set Date box to YMD and press finish Done! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Crauwf" wrote in message ... I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
If you are looking for a formula solution for use in a different column, try
this... =--TEXT(A1,"0000-00-00") -- Rick (MVP - Excel) "Crauwf" wrote in message ... I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
=--TEXT(A1,"0000\-00\-00") and format as date.
-- David Biddulph "Crauwf" wrote in message ... I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
On Tue, 9 Dec 2008 10:27:00 -0800, Crauwf
wrote: I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. =TEXT(--TEXT(A1,"0000\/00\/00"),"dd/mm/yyyy") or, if you are going to use this in calculations: =--TEXT(A1,"0000\/00\/00") and format as "mm/dd/yyyy" --ron |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
Thanks for your help. This was the simplest and most helpful of the bunch.
Thanks again. "Niek Otten" wrote: =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) -- Kind regards, Niek Otten Microsoft MVP - Excel "Crauwf" wrote in message ... I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changine text into a date
Great stuff very helpful. Thank you....
"Bernard Liengme" wrote: Select the range of cells to be converted Use Data | Text to Columns Use Delimits, click Next until you get to step 3 Set Date box to YMD and press finish Done! best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Crauwf" wrote in message ... I have the following date 20081128 How do I convert this figure to the date 28/11/2008? Can anyone help? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert a text date to a true date | Excel Discussion (Misc queries) | |||
| how do i change text format date to date (i.e., mm/yy to mm/dd/yyy | Excel Discussion (Misc queries) | |||
| how do i convert text to date (mm/yy text to mm/dd/yyyy date)? | Excel Discussion (Misc queries) | |||
| Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
| Help: How do I convert a text date into a real date format | Excel Worksheet Functions | |||
Linear Mode
