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