Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | | | |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | | | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
International/Date issue
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 | | | | | | | | | | | | |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 | | | | | | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how format date with TEXT() function for international usage? | Excel Worksheet Functions | |||
Date issue | Excel Worksheet Functions | |||
Texttocolumns and Date Format using Macro - UK International setti | Excel Programming | |||
International Date Conversion to Values | Excel Programming | |||
International issue (Excel XP) | Excel Programming |