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?

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?

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

Sorry. It works for me (french settings) :
Selection.NumberFormat = "[Green]0.00_ ;[Red]-0.00"
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?
>>
>>
>>

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

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