B
Barbara
Hi,
How can I convert 80207 to 08/02/07 (date format)?
thanks,
Barbara
How can I convert 80207 to 08/02/07 (date format)?
thanks,
Barbara
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Teethless mama
=--TEXT(A1,"00\/00\/00")
Format cell as: m/dd/yy
Format cell as: m/dd/yy
G
Gord Dibben
Data>Text to Columns>Next>Next>Column Data Format>Date>MDY>Finish
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
B
Barbara
Thank you very much! It works fine.
"Teethless mama" escreveu:
"Teethless mama" escreveu:
B
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:
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:
S
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
[email protected]
Replace @mailinator.com with @tiscali.co.uk
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
[email protected]
Replace @mailinator.com with @tiscali.co.uk