DATE format!

[Guest]

Hi,
How can I convert 80207 to 08/02/07 (date format)?

thanks,
Barbara

 

[Guest]

=--TEXT(A1,"00\/00\/00")

Format cell as: m/dd/yy

 

[Gord Dibben]

Data>Text to Columns>Next>Next>Column Data Format>Date>MDY>Finish


Gord Dibben MS Excel MVP

 

[Guest]

Thank you very much! It works fine.


"Teethless mama" escreveu:

 

[Barbara]

Hi,

What am I doing wrong, today???

I enter your formula as bellow for cell A1=20107 and in B1 I get = 1-07-02.
My cell is formated mm-dd-yy. I need to get 02/01/2007 (dd-mm-yyyy).

Can someone helpe me on this one.....
Thanks a lot.
Barbara




"Teethless mama" escreveu:

 

[Sandy Mann]

Teethless mama's formula works for me with the cell formatted as dd-mm-yyyy

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk