International/Date issue

[Niek Otten]

If you choose Date in Format>Cells>Number tab, you get a Locale option. So I can choose to have Dutch weekday names in an English
version of Excel.
The option is not available in the Number>Custom dialog.
So I recorded a macro when formatting with a locale, to find out how to set it from VBA. It seems it's not being recorded.
I searched for "locale" in both worksheet and VBA help, but didn't find anything useful.
Google group search didn't help me either.
Does anybody know how to set the locale in a Custom format (I need just the name of the weekday, which is not one of the options
in the Date dialog).
Of course I know there are many worksheet formula solutions, but that's not what I'm looking for right now.

Thanks,

Niek Otten

 

[Bob Phillips]

I would think you are out of luck Niek.

In custom format you can specify the international code so as to get the
currency symbol say *Irish Euros - [$?-1809]#,##0.00;-[$?-1809]#,##0.00),
but that is working on numbers not text.

Unless you mean a custom format of

[$-413] ddd

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Niek Otten]

<[$-413] ddd>

That's it, Bob!

I vaguely remembered having seen something like this, but I couldn't find it anywhere.

Thanks!

Niek
|I would think you are out of luck Niek.
|
| In custom format you can specify the international code so as to get the
| currency symbol say *Irish Euros - [$?-1809]#,##0.00;-[$?-1809]#,##0.00),
| but that is working on numbers not text.
|
| Unless you mean a custom format of
|
| [$-413] ddd
|
| --
| HTH
|
| Bob
|
| (there's no email, no snail mail, but somewhere should be gmail in my addy)
|
| | > If you choose Date in Format>Cells>Number tab, you get a Locale option. So
| > I can choose to have Dutch weekday names in an English
| > version of Excel.
| > The option is not available in the Number>Custom dialog.
| > So I recorded a macro when formatting with a locale, to find out how to
| > set it from VBA. It seems it's not being recorded.
| > I searched for "locale" in both worksheet and VBA help, but didn't find
| > anything useful.
| > Google group search didn't help me either.
| > Does anybody know how to set the locale in a Custom format (I need just
| > the name of the weekday, which is not one of the options
| > in the Date dialog).
| > Of course I know there are many worksheet formula solutions, but that's
| > not what I'm looking for right now.
| >
| > Thanks,
| >
| > Niek Otten
| >
| >
|
|

 

[Bob Phillips]

The one thing that doesn't give, which would be nice, is the day, month,
year identifier, such as tt, mm and jj

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Niek Otten]

Yes, that would be nice. It is always a problem where one uses literals, like in the TEXT() function; the literals are not
translated.
It gets even more complicated if you have a multi-language version of Office: the function names get translated (except ATP
functions), the literals aren't.
And then in Excel 2007 there is a problem with translation of functions that used to be ATP, but now are (should be) built-in
functions.

What about an Esperanto version of Excel?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| The one thing that doesn't give, which would be nice, is the day, month,
| year identifier, such as tt, mm and jj
|
| --
| HTH
|
| Bob
|
| (there's no email, no snail mail, but somewhere should be gmail in my addy)
|
| | > <[$-413] ddd>
| >
| > That's it, Bob!
| >
| > I vaguely remembered having seen something like this, but I couldn't find
| > it anywhere.
| >
| > Thanks!
| >
| > Niek
| > | > |I would think you are out of luck Niek.
| > |
| > | In custom format you can specify the international code so as to get the
| > | currency symbol say *Irish Euros -
| > [$?-1809]#,##0.00;-[$?-1809]#,##0.00),
| > | but that is working on numbers not text.
| > |
| > | Unless you mean a custom format of
| > |
| > | [$-413] ddd
| > |
| > | --
| > | HTH
| > |
| > | Bob
| > |
| > | (there's no email, no snail mail, but somewhere should be gmail in my
| > addy)
| > |
| > | | > | > If you choose Date in Format>Cells>Number tab, you get a Locale
| > option. So
| > | > I can choose to have Dutch weekday names in an English
| > | > version of Excel.
| > | > The option is not available in the Number>Custom dialog.
| > | > So I recorded a macro when formatting with a locale, to find out how
| > to
| > | > set it from VBA. It seems it's not being recorded.
| > | > I searched for "locale" in both worksheet and VBA help, but didn't
| > find
| > | > anything useful.
| > | > Google group search didn't help me either.
| > | > Does anybody know how to set the locale in a Custom format (I need
| > just
| > | > the name of the weekday, which is not one of the options
| > | > in the Date dialog).
| > | > Of course I know there are many worksheet formula solutions, but
| > that's
| > | > not what I'm looking for right now.
| > | >
| > | > Thanks,
| > | >
| > | > Niek Otten
| > | >
| > | >
| > |
| > |
| >
| >
|
|

 

[Bob Phillips]

These are the sort of things they could have added in 2007 and been really
useful, rather than trashing F4.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Yes, that would be nice. It is always a problem where one uses literals,
like in the TEXT() function; the literals are not
translated.
It gets even more complicated if you have a multi-language version of
Office: the function names get translated (except ATP
functions), the literals aren't.
And then in Excel 2007 there is a problem with translation of functions
that used to be ATP, but now are (should be) built-in
functions.

What about an Esperanto version of Excel?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| The one thing that doesn't give, which would be nice, is the day, month,
| year identifier, such as tt, mm and jj
|
| --
| HTH
|
| Bob
|
| (there's no email, no snail mail, but somewhere should be gmail in my
addy)
|
| | > <[$-413] ddd>
| >
| > That's it, Bob!
| >
| > I vaguely remembered having seen something like this, but I couldn't
find
| > it anywhere.
| >
| > Thanks!
| >
| > Niek
| > | > |I would think you are out of luck Niek.
| > |
| > | In custom format you can specify the international code so as to get
the
| > | currency symbol say *Irish Euros -
| > [$?-1809]#,##0.00;-[$?-1809]#,##0.00),
| > | but that is working on numbers not text.
| > |
| > | Unless you mean a custom format of
| > |
| > | [$-413] ddd
| > |
| > | --
| > | HTH
| > |
| > | Bob
| > |
| > | (there's no email, no snail mail, but somewhere should be gmail in
my
| > addy)
| > |
| > | | > | > If you choose Date in Format>Cells>Number tab, you get a Locale
| > option. So
| > | > I can choose to have Dutch weekday names in an English
| > | > version of Excel.
| > | > The option is not available in the Number>Custom dialog.
| > | > So I recorded a macro when formatting with a locale, to find out
how
| > to
| > | > set it from VBA. It seems it's not being recorded.
| > | > I searched for "locale" in both worksheet and VBA help, but didn't
| > find
| > | > anything useful.
| > | > Google group search didn't help me either.
| > | > Does anybody know how to set the locale in a Custom format (I need
| > just
| > | > the name of the weekday, which is not one of the options
| > | > in the Date dialog).
| > | > Of course I know there are many worksheet formula solutions, but
| > that's
| > | > not what I'm looking for right now.
| > | >
| > | > Thanks,
| > | >
| > | > Niek Otten
| > | >
| > | >
| > |
| > |
| >
| >
|
|