CDec: international syntax for argument string with decimals

[6diegodiego9]

My Excel is set in English for everything (formula, interface, guide).
My Windows is set with "," for decimal symbol and with "." for Digit grouping symbol in regional settings, as I live in Italy.

If I write this code:

Please Login or Register  to view this content.

result is displayed as "12345678901234567050,123456789" (Variant/Decimal) in Locals window. Same if I msgbox it.

If I use "." instead than ",", result is 12345678901234567000123456839.

In VBA, when writing numbers (in form of numbers, not strings), I must use the english syntax i.e. "." for decimal symbol.

I believe that that code of my example would run wrongly by a Windows with English regional settings.

How can I (modify it to) make it run correctly with any regional settings?

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Kaper]

You can easily test which decimal separator is currently used (on a computer where the excel file is open), by using:

Please Login or Register  to view this content.

so (it is not the solution for working code , just a demopnstration):

Please Login or Register  to view this content.

will always work as expected

[6diegodiego9]

Wonderful, thanks Kaper!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.