Application.DecimalSeparator

[Niek Otten]

Hi all,

I use Application.DecimalSeparator in a function to strip characters from a string and leave just a number.
I noticed that, if you have Tools>Options>International, Use system separators checked, this will not be reflected in
Application.DecimalSeparator.
Can anybody tell me what I should use to get that?

Thanks,

 

[Jim Cone]

Hi Niek,
Something to try...
Application.International(xlDecimalSeparator)
Application.International(xlThousandsSeparator)
Regards,
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Niek Otten" <[email protected]>
wrote in message
Hi all,
I use Application.DecimalSeparator in a function to strip characters from a string and leave just a number.
I noticed that, if you have Tools>Options>International, Use system separators checked, this will not be reflected in
Application.DecimalSeparator.
Can anybody tell me what I should use to get that?
Thanks,

 

[Niek Otten]

Thanks, Jim!

That seems to work.

--
Kind regards,

Niek Otten

| Hi Niek,
| Something to try...
| Application.International(xlDecimalSeparator)
| Application.International(xlThousandsSeparator)
| Regards,
| Jim Cone
| San Francisco, USA
| http://www.realezsites.com/bus/primitivesoftware
|
|
|
| "Niek Otten" <[email protected]>
| wrote in message
| Hi all,
| I use Application.DecimalSeparator in a function to strip characters from a string and leave just a number.
| I noticed that, if you have Tools>Options>International, Use system separators checked, this will not be reflected in
| Application.DecimalSeparator.
| Can anybody tell me what I should use to get that?
| Thanks,
| --
| Kind regards,
| Niek Otten
|
|
|
|