Is there a way for RB to know whether the system is set to use a comma as a decimal separator or a period as a decimal separator?
s = Format(1, “.”)
Yes, that will format the string, but depending on whether its the US version or foreign version sometimes I want to format it with a comma and sometimes with a period.
Read the documentation for the Format command:
s = Format(1.5, "0.0")
will automatically format the decimal using the system settings. You don’t need to do anything extra.
However, if you actually do need to know whether it will be a period or comma, just run the above line., and check the formatted string to determine which character is used.