1
vote
1answer
1k views

Easy way to one-off import data with different decimal separator in Excel?

My OS's locale uses the comma as a decimal separator. However, once in a while I need to process data in Excel which is formatted with a point as decimal separator. Depending on the source of the ...
1
vote
1answer
498 views

How to enter formulas in Excel in other locales (with different decimal separators)?

I'm getting a strange error in Excel where I cannot enter formulas: =ROUND(1.5,0) gives an error: The formula you typed contains an error I presume it has something to do with the (red ...