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)

"Rodrigo Ferreira" wrote in message
...
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

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.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rodrigo Ferreira" wrote in message
...
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

Ok Bob, but I want the current list

Rodrigo Ferreira



"Bob Phillips" escreveu na mensagem
...
It is open-ended as you can define your own.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rodrigo Ferreira" wrote in message
...
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

ok. But I want the current list (using VBA)

Rodrigo Ferreira


"cdris7319" escreveu na mensagem
...
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.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rodrigo Ferreira" wrote in message
...
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