Date Conversion

[Jason Trolian]

I need to convert a date that is formatted mm/dd/yyyy and
format yyyy/mm/dd. It is important as well that in case
of a date like 03/01/2004 appears 2004/03/01 (with the
zeros not 2004/3/1). Can anyone point me in the right
direction?

Thank you in advance,
Jason

 

[Frank Kabel]

Hi Jason
if this date is stored as real date in Excel (and not as string) just
goto 'Format - Cells' and choose/enter a date format like
YYYY/MM/DD

or if you want a text value try the following formula (source date is
in A19
=TEXT(A1,"YYYY/MM/DD")

 

[Jason Trolian]

This is a real date in excel. I am using office 2000. I
do not have a formating option = to yyyy/mm/dd in
formating.

JT

 

[Guest]

Correction, I got it to work with the =TEXT
(cell,"yyyy/mm/dd")

Thanks for the help

 

[Frank Kabel]

Hi Jason
just go to the 'custom format' category in the format cells dialog and
enter manually
YYYY/MM/DD