| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom NumberFormat - international version
I am trying to setup a custom NumberFormat in the way that could be used in
different regional settings. For example, I would like to have "[Green]0,00_ ;[Red]-0,00" applicable to US / DE / UK / RU / whatever else settings. Currently I get an error when I try to move this code from one PC to another. Is there a way to make NumberFormat culture independent? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom NumberFormat - international version
You should try :
"[Green]0.00_ ;[Red]-0.00" Regards. Daniel I am trying to setup a custom NumberFormat in the way that could be used in different regional settings. For example, I would like to have "[Green]0,00_ ;[Red]-0,00" applicable to US / DE / UK / RU / whatever else settings. Currently I get an error when I try to move this code from one PC to another. Is there a way to make NumberFormat culture independent? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom NumberFormat - international version
yes, and I get the following message (I try to set it in the code, not UI)
Microsoft Office Excel cannot use the number format you typed. Try using one of the built-in number formats. On the Format menu, click Cells, and then click the Number tab. Select the category you want, and then choose other options. "Daniel.C" wrote: You should try : "[Green]0.00_ ;[Red]-0.00" Regards. Daniel I am trying to setup a custom NumberFormat in the way that could be used in different regional settings. For example, I would like to have "[Green]0,00_ ;[Red]-0,00" applicable to US / DE / UK / RU / whatever else settings. Currently I get an error when I try to move this code from one PC to another. Is there a way to make NumberFormat culture independent? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom NumberFormat - international version
this is where I got this string from and trying to use it via .COM
"Daniel.C" wrote: Did you try to use the macro recorder ? Daniel yes, and I get the following message (I try to set it in the code, not UI) Microsoft Office Excel cannot use the number format you typed. Try using one of the built-in number formats. On the Format menu, click Cells, and then click the Number tab. Select the category you want, and then choose other options. "Daniel.C" wrote: You should try : "[Green]0.00_ ;[Red]-0.00" Regards. Daniel I am trying to setup a custom NumberFormat in the way that could be used in different regional settings. For example, I would like to have "[Green]0,00_ ;[Red]-0,00" applicable to US / DE / UK / RU / whatever else settings. Currently I get an error when I try to move this code from one PC to another. Is there a way to make NumberFormat culture independent? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Wrap Text: Print Version different than Screen Version | Excel Discussion (Misc queries) | |||
| Replace existing custom toolbar with an updated version | Excel Programming | |||
| Strange listbox behavior in version 2003 after version 2007 | Excel Programming | |||
| Help Required!!! Macro to load data from version 1 to version 2 | Excel Worksheet Functions | |||
| Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
Linear Mode
