Cell: date and day format

  • Thread starter Thread starter Bobby
  • Start date Start date
B

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!
 
Bobby said:
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?
Click to expand...

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 -----
 
Hello Bobby,

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



Mit freundlichen Grüssen
Claus Busch
 
Hello Bobby,

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

Mit freundlichen Grüssen
Claus Busch
Click to expand...

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 said:
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
Click to expand...

Ach du lieber! Seriously, great pointer!


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

Claus Busch said:
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
Click to expand...


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

Hello Bobby,

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



Mit freundlichen Grüssen
Claus Busch
 
Claus Busch said:
Am Sun, 4 Oct 2009 12:49:41 -0700 (PDT) schrieb Bobby:
Click to expand...
it's a german site, but you can find the country-codes
for formatting your date:
http://www.excelformeln.de/formeln.html?welcher=422
Click to expand...

Ach du lieber!  Seriously, great pointer!

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






Hello Bobby,
Click to expand...
Am Sun, 4 Oct 2009 12:49:41 -0700 (PDT) schrieb Bobby:
Click to expand...
it's a german site, but you can find the country-codes for formatting your
date:
http://www.excelformeln.de/formeln.html?welcher=422
Click to expand...
Mit freundlichen Grüssen
Claus Busch
Click to expand...

----- 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 -
Click to expand...

Danke schön!
 
Ach du lieber! Seriously, great pointer!
Click to expand...

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
 
Bobby said:
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!
Click to expand...
Change location to french (in cells format dialog box)
 
Bobby said:
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!
Click to expand...
Or use that full format [$-40C]dddd-dd-mmm-yy;@
 
Back
Top