ExcelBanter - International/Date issue

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - International/Date issue (https://www.excelbanter.com/excel-programming/414355-international-date-issue.html)

International/Date issue

If you choose Date in FormatCellsNumber 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 NumberCustom 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

International/Date issue

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" wrote in message
...
If you choose Date in FormatCellsNumber 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 NumberCustom 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

International/Date issue

<[$-413] ddd

That's it, Bob!

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

Thanks!

Niek
"Bob Phillips" wrote in message ...
|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" wrote in message
| ...
| If you choose Date in FormatCellsNumber 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 NumberCustom 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
|
|
|
|

International/Date issue

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" wrote in message
...
<[$-413] ddd

That's it, Bob!

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

Thanks!

Niek
"Bob Phillips" wrote in message
...
|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" wrote in message
| ...
| If you choose Date in FormatCellsNumber 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 NumberCustom 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
|
|
|
|

International/Date issue

International/Date issue

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)

"Niek Otten" wrote in message
...
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

"Bob Phillips" wrote in message
...
| 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" wrote in message
| ...
| <[$-413] ddd
|
| That's it, Bob!
|
| I vaguely remembered having seen something like this, but I couldn't
find
| it anywhere.
|
| Thanks!
|
| Niek
| "Bob Phillips" wrote in message
| ...
| |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" wrote in message
| | ...
| | If you choose Date in FormatCellsNumber 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 NumberCustom 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
| |
| |
| |
| |
|
|
|
|