Date Conversion

  • Thread starter Thread starter Jason Trolian
  • Start date Start date
J

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
 
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")
 
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
 
Hi Jason
just go to the 'custom format' category in the format cells dialog and
enter manually
YYYY/MM/DD
 
Back
Top