yyyy-mm-dd date format?

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
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
How to add day to PWA 2016 date format? 0
Date Formats 4
is it possible to sort by approximate date? 2
Forcing a date entry format of dd/mm/yyyy 1
reformat dates to yyyy/mm/dd 5
Date Formats 1
Convert dates stored as text 2

Top