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