I have rows of numbers in the wrong format. Current format is 1 000,00 needs changing to 1000.00 . How can I change this format?

CodePudding user response：

I imagine you can adjust it here: https://i.stack.imgur.com/apbpC.png

If not, it may be your language settings in the browser / your computer that it's taking your default format from.

CodePudding user response：

I pasted (value) the numbers to a new spreadsheet, changed the language settings to Polish, applied format as currency, then copied and pasted (with format) to the original spreadsheet.