Currently Being ModeratedDec 7, 2012 9:44 PM (in response to KiteSurfer)
Numbers uses the regional setting inn System Preferences > International to set your default number and currency formats.
Brazil is a sub-set of Portuguese, found well down the list:
You could choose any region which uses the comma as the decimal separator, but choosing Brazil should also set the Real as the currency symbol.
Currently Being ModeratedDec 8, 2012 4:35 AM (in response to Barry)
Are you suggesting that I make this preference change just prior to working on a Brazlian spreadsheet?... and I assume return the preferences to my regular (USA/English) default when I'm finished with the spreadsheet?
I assume I would have to save the spreadsheet as a PDF file or something similar to preserve its Brazilian currency formatting prior to returning to those original USA/English default settings. Is that correct?
Currently Being ModeratedDec 8, 2012 4:20 PM (in response to KiteSurfer)
I don't know of a way to make the change specific to a particular spreadsheet. As Barry said, it is a system-wide setting.
If you change your settings so a point is the thousands separator and a comma is for decimals, all spreadsheets will take on that format when you look at them. Change back to US standard formatting and they'll all display with the US standard number formatting. So you don't have to save the spreadsheet as a PDF to preserve it, just change back to the Brazilian number format before you open it.
I wish there was a method to quickly change from one format to the other. You can change input devices (i.e, keyboard mappings) with a mouse click but, as far as I know, not the number & date format settings. Maybe a third-party app is available to provide quick switching. I'm sure you're not the only one who needs it.
Currently Being ModeratedDec 8, 2012 10:26 PM (in response to Badunit)
Thanks for stepping in with that clarification.