Hi everyone,
I'm working on some macro tool which uses standard "Get External data" feature for automatic currency rates retrieval from website.
The problem is that this tool is used by different users and they have different settings for the decimal symbol ( , or . ) and digit grouping ( ' or . ), this leads to #VALUE! error when formulas tries to calculate numbers with different settings.
Ex:
3.5*2.5=8.75 but
3.5*2,5=#VALUE!
How can i overcome this problem?
I'm working on some macro tool which uses standard "Get External data" feature for automatic currency rates retrieval from website.
The problem is that this tool is used by different users and they have different settings for the decimal symbol ( , or . ) and digit grouping ( ' or . ), this leads to #VALUE! error when formulas tries to calculate numbers with different settings.
Ex:
3.5*2.5=8.75 but
3.5*2,5=#VALUE!
How can i overcome this problem?