I have Calc spreadsheets which are by default in the French number format. I have no idea how this came about except that I live in France and the second language on my laptop is French. In system settings/Language Support, Language and Regional Formats I have English UK. On changing the number format for all cells in the Calc Spreadsheet I can work in English but each time I save and close the file it reverts to French. I have also tried to save the re-formatted number format file as another name but the same thing happens, it reverts to the Default French when I close and reopen it. I built this spreadsheet years ago and it is quite complex so I would prefer being able to revert it to its' original English number format. Does anyone have any ideas?
SnapOverflow
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.