List of all "Date Formats" from Excel

  • Thread starter Thread starter Rodrigo Ferreira
  • Start date Start date
R

Rodrigo Ferreira

How can I get the list of all "Date Formats" from Excel?
Something like this:
dd/mm/yyyy
mm/dd/yyyy
yyyy-mm-dd
....

Rodrigo Ferreira
 
It is open-ended as you can define your own.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You can get a starter list though by hilighting a cell, right click, select
"format cell" from drop down menu, pick the "number" tab then look at the
options provided under the "date" and "custom" headings.
 

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

date 1
Excel 2002: How to make the date format uniform ? 1
Date Formats 1
Date format changes in mail merge using Excel worksheet as data 2
Date automatically swaps 6
Convert dates stored as text 2
reformat dates to yyyy/mm/dd 5
Change of date format when syncing Excel 2007 to Excel Mobilw 8

Back
Top