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
--
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.

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Crauwf" <(E-Mail Removed)> wrote in message
news:69716F0B-CD00-4609-AF11-(E-Mail Removed)...
>I have the following date 20081128
>
> How do I convert this figure to the date 28/11/2008?
>
> Can anyone help?
>
> Thanks.

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" <(E-Mail Removed)> wrote in message
news:69716F0B-CD00-4609-AF11-(E-Mail Removed)...
>I have the following date 20081128
>
> How do I convert this figure to the date 28/11/2008?
>
> Can anyone help?
>
> Thanks.

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" <(E-Mail Removed)> wrote in message
news:69716F0B-CD00-4609-AF11-(E-Mail Removed)...
>I have the following date 20081128
>
> How do I convert this figure to the date 28/11/2008?
>
> Can anyone help?
>
> Thanks.

On Tue, 9 Dec 2008 10:27:00 -0800, Crauwf <(E-Mail Removed)>
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

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" <(E-Mail Removed)> wrote in message
> news:69716F0B-CD00-4609-AF11-(E-Mail Removed)...
> >I have the following date 20081128
> >
> > How do I convert this figure to the date 28/11/2008?
> >
> > Can anyone help?
> >
> > Thanks.
>

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" <(E-Mail Removed)> wrote in message
> news:69716F0B-CD00-4609-AF11-(E-Mail Removed)...
> >I have the following date 20081128
> >
> > How do I convert this figure to the date 28/11/2008?
> >
> > Can anyone help?
> >
> > Thanks.
>
>
>