Hello-
I've made a large Excel file (lots of sheets, lots of complex formula), and when used by others in Europe it changes number formats correspondingly.
So "," turns to "." for example (where in most European languages the decimal separator is a comma). This in turns "breaks" the file somehow, and I'm trying to troubleshoot where it is breaking.
Is there an easy way in Excel for Mac 2011 to switch over from US to European number format so I am seeing the spreadsheet as someone in Europe would when opening?
Thanks everyone
I've made a large Excel file (lots of sheets, lots of complex formula), and when used by others in Europe it changes number formats correspondingly.
So "," turns to "." for example (where in most European languages the decimal separator is a comma). This in turns "breaks" the file somehow, and I'm trying to troubleshoot where it is breaking.
Is there an easy way in Excel for Mac 2011 to switch over from US to European number format so I am seeing the spreadsheet as someone in Europe would when opening?
Thanks everyone