Application.DecimalSeparator
 

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 ToolsOptionsInternational, 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

Application.DecimalSeparator
 

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"
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 ToolsOptionsInternational, 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

Application.DecimalSeparator
 

Thanks, Jim!

That seems to work.

--
Kind regards,

Niek Otten

"Jim Cone" wrote in message ...
| 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"
| 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 ToolsOptionsInternational, 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
|
|
|
|