yyyy-mm-dd date format?

  • Thread starter Thread starter EllenM
  • Start date Start date
E

EllenM

Hello,
Is it possible to express dates in a yyyy-mm-dd format? We have dates in a
functionality that sorts dates as text.

Thanks in advance for your help.

Ellen
 
hi
you could create a custom format. right click the cell, click format cells.
click the number tab. click custom. in the custom box enter.
yyy/mm/dd

click ok.
you can copy the formated cell and paste special formats where ever you like.

regards
FSt1
 
Back
Top