PC Review


Reply
Thread Tools Rate Thread

Changine text into a date

 
 
Crauwf
Guest
Posts: n/a
 
      9th Dec 2008

I have the following date 20081128

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

Can anyone help?

Thanks.
 
Reply With Quote
 
 
 
 
Luke M
Guest
Posts: n/a
 
      9th Dec 2008

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

 
Reply With Quote
 
Niek Otten
Guest
Posts: n/a
 
      9th Dec 2008

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


 
Reply With Quote
 
Bernard Liengme
Guest
Posts: n/a
 
      9th Dec 2008
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.



 
Reply With Quote
 
Rick Rothstein
Guest
Posts: n/a
 
      9th Dec 2008

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.


 
Reply With Quote
 
Ron Rosenfeld
Guest
Posts: n/a
 
      9th Dec 2008

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
 
Reply With Quote
 
Crauwf
Guest
Posts: n/a
 
      10th Dec 2008
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.

>

 
Reply With Quote
 
Crauwf
Guest
Posts: n/a
 
      10th Dec 2008
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.

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exit Access without changine MDB file date =?Utf-8?B?TXIgRUQgPD48?= Microsoft Access 2 17th Jan 2005 09:40 PM
changine registered computer name Derek Microsoft Windows 2000 Registry Archive 1 6th Oct 2004 07:04 PM
changine registered computer name Derek Microsoft Windows 2000 Registry 1 6th Oct 2004 07:04 PM
Re: Changine fonts on all slides Glen Millar Microsoft Powerpoint 0 4th Nov 2003 10:11 PM
Re: Changine fonts on all slides DanP Microsoft Powerpoint 0 4th Nov 2003 06:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:03 PM.