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