Convert decimal numbers

[SanbiVN]

Your code uses the CDec function, which causes an error when the system sets the Comma character as the decimal separator. In this case, you must replace the period with a comma before using the function. The Val function doesn't require this because it uses a period as the decimal separator. However, the Val function only supports a limited number of 14 decimal digits.

[cristianbuse]

@SanbiVN This repo already handles the decimal separator regardless of the regional settings. Can you provide an example of a combination of setting and code that can trigger the error? Thanks!

[SanbiVN]

I've read the source code, and I don't understand how your code handles it. But it's clever; you used CStr to get the decimal separator without needing any complicated code.

chDot = AscW(Mid$(CStr(1.1), 2, 1))

The code I usually use to handle the decimal separator is:

IIF("1.1" = 1.1,".",",")

Thank you. LibJson is quite powerful for parsing JSON.

[cristianbuse]

Thank you for the kind words!

Just a note, because you mentioned the Val method. Unfortunately Val would lose precision for Decimal and would only retain precision for Double values. As a bonus, the adopted method is also faster than using Val.