Cell: date and day format

[Bobby]

I use Excel 2003 in English. I use custom format for date output in a
cell . For example:
dddd-dd-mmm-yyyy gives me Sun-04-Oct-2009 . Do I have to write a macro
to obtain the:
Dim(French) instead of Sun or is there a another way?

Thank's ahead!

 

[JoeU2004]

dddd-dd-mmm-yyyy gives me Sun-04-Oct-2009 .
Do I have to write a macro to obtain the:
Dim(French) instead of Sun or is there a another way?

Well, you could change your computer's Regional and Language control setting
to French.

But note that that could also change the month abbreviation. For example,
Aug becomes Aout (with a circumflex over the "u").


----- original message -----

 

[Claus Busch]

Hello Bobby,

try this:
[$-40C]ddd-dd-mmm-yyyy



Mit freundlichen Grüssen
Claus Busch

 

[Bobby]

Hello Bobby,

try this:
[$-40C]ddd-dd-mmm-yyyy

Mit freundlichen Grüssen
Claus Busch

Claus, I am impressed! This is it. Thank you!
Question?
Where can I read about these symbols and ther function?
Thank's ahead

 

[Claus Busch]

Hello Bobby,

Am Sun, 4 Oct 2009 12:49:41 -0700 (PDT) schrieb Bobby:

Where can I read about these symbols and ther function?

it's a german site, but you can find the country-codes for formatting your
date:
http://www.excelformeln.de/formeln.html?welcher=422


Mit freundlichen Grüssen
Claus Busch

 

[JoeU2004]

Am Sun, 4 Oct 2009 12:49:41 -0700 (PDT) schrieb Bobby:

it's a german site, but you can find the country-codes
for formatting your date:
http://www.excelformeln.de/formeln.html?welcher=422

Ach du lieber! Seriously, great pointer!


----- original message -----

Hello Bobby,

Am Sun, 4 Oct 2009 12:49:41 -0700 (PDT) schrieb Bobby:


it's a german site, but you can find the country-codes for formatting your
date:
http://www.excelformeln.de/formeln.html?welcher=422


Mit freundlichen Grüssen
Claus Busch

----- previous message -----

Hello Bobby,

try this:
[$-40C]ddd-dd-mmm-yyyy



Mit freundlichen Grüssen
Claus Busch

 

[Bobby]

Am Sun, 4 Oct 2009 12:49:41 -0700 (PDT) schrieb Bobby:

it's a german site, but you can find the country-codes
for formatting your date:
http://www.excelformeln.de/formeln.html?welcher=422

Ach du lieber!  Seriously, great pointer!

----- original message -----

Hello Bobby,

Am Sun, 4 Oct 2009 12:49:41 -0700 (PDT) schrieb Bobby:

it's a german site, but you can find the country-codes for formatting your
date:
http://www.excelformeln.de/formeln.html?welcher=422

Mit freundlichen Grüssen
Claus Busch

----- previous message -----

Hello Bobby,

try this:
[$-40C]ddd-dd-mmm-yyyy

Mit freundlichen Grüssen
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2- Hide quoted text -

- Show quoted text -

Danke schön!

 

[Jerry W. Lewis]

Please excuse the completely off topic post, JoeU2004, but check back to your
programming question from last month
http://groups.google.com/group/micr...ramming/browse_thread/thread/bedfc706182109f3
which has a new response.

Jerry

 

[Ron Rosenfeld]

Ach du lieber! Seriously, great pointer!

You can also generate these codes (at least in more recent versions of Excel),
by selecting Format/Cells/Number Date and selecting one of the country formats
that at least has the month and/or day spelled out. Then go to the Custom Type
and modify it. It should have the country specific code prepended.
--ron

 

[Grégory H.]

I use Excel 2003 in English. I use custom format for date output in a
cell . For example:
dddd-dd-mmm-yyyy gives me Sun-04-Oct-2009 . Do I have to write a macro
to obtain the:
Dim(French) instead of Sun or is there a another way?

Thank's ahead!

Change location to french (in cells format dialog box)

 

[Grégory H.]

I use Excel 2003 in English. I use custom format for date output in a
cell . For example:
dddd-dd-mmm-yyyy gives me Sun-04-Oct-2009 . Do I have to write a macro
to obtain the:
Dim(French) instead of Sun or is there a another way?

Thank's ahead!

Or use that full format [$-40C]dddd-dd-mmm-yy;@