Changine text into a date

  • Thread starter Thread starter Crauwf
  • Start date Start 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.
 
=DATE(VALUE(LEFT(A1,4)),VALUE(MID(A1,5,2)),VALUE(RIGHT(A1,2)))
and custom format the cell to:
dd/mm/yyyy
 
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
 
If you are looking for a formula solution for use in a different column, try
this...

=--TEXT(A1,"0000-00-00")
 
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
 
Thanks for your help. This was the simplest and most helpful of the bunch.
Thanks again.
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining 2 Tables Dynamically into third new Table 1
Finding the week of date 4
Date between date range 1
Automatically update a cell with a date based on anther cells date 2
Converting date format 4
Formatting Date Field 5
Change Mar 25 in to Date? 5
date to text 1

Back
Top