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
| |
| |
| |
| |
|
|
|
|