DATE format!
 

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

thanks,
Barbara

DATE format!
 

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

Format cell as: m/dd/yy


"Barbara" wrote:

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

thanks,
Barbara

DATE format!
 

DataText to ColumnsNextNextColumn Data FormatDateMDYFinish


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 09:58:24 -0800, Barbara
wrote:

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

thanks,
Barbara

DATE format!
 

Thank you very much! It works fine.


"Teethless mama" escreveu:

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

Format cell as: m/dd/yy


"Barbara" wrote:

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

thanks,
Barbara

DATE format!
 

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:

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

Format cell as: m/dd/yy


"Barbara" wrote:

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

thanks,
Barbara

DATE format!
 

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


Replace @mailinator.com with @tiscali.co.uk


"Barbara" wrote in message
...
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:

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

Format cell as: m/dd/yy


"Barbara" wrote:

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

thanks,
Barbara