Changine text into a date

C

Crauwf

I have the following date 20081128

How do I convert this figure to the date 28/11/2008?

Can anyone help?

Thanks.
 
L

Luke M

=DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(RIGHT(A1,2)))
and custom format the cell to:
dd/mm/yyyy
 
B

Bernard Liengme

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
 
R

Rick Rothstein

If you are looking for a formula solution for use in a different column, try
this...

=--TEXT(A1,"0000-00-00")
 
R

Ron Rosenfeld

I have the following date 20081128

How do I convert this figure to the date 28/11/2008?

Can anyone help?

Thanks.
Click to expand...

=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
 
C

Crauwf

Thanks for your help. This was the simplest and most helpful of the bunch.
Thanks again.
 
C

Crauwf

Great stuff very helpful. Thank you....

Bernard Liengme said:
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
Click to expand...
 
Top