| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| difference application.quit & application.close | Excel Programming | |||
| Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
| Replace application.RTD property by Application.RTDServers collect | Excel Programming | |||
| macro to close excel application other than application.quit | Excel Programming | |||
| Application.DecimalSeparator usage. | Excel Programming | |||
Linear Mode
