Skip navigation

Substituting Commas for Decimal Points on Foreign Currency Spreadsheets

621 Views 4 Replies Latest reply: Dec 8, 2012 10:26 PM by Barry RSS
KiteSurfer Level 1 Level 1 (0 points)
Currently Being Moderated
Dec 7, 2012 8:04 PM

I'm trying to produce a spreadsheet using Brazilian Currency. Conveniently, one can select the Cell Format window in the Inspector, choose Currency from the pulldown menu and select the Brazilian Real (R$) from the Symbol pulldown menu. Unfortunately, Numbers does not automatically reformat the cells to reflect true notation of the Brazilian Real, which uses a (demical) point/period as the thousands separator, and conversely, uses a comma as a decimal point.

 

Does anyone know a fast and easy way to implement this switch?... i.e., to make every Currency Cell use a point/period for a thousands separator, and a comma for a decimal point?

 

Thanks!

  • Barry Level 7 Level 7 (29,095 points)

    Numbers uses the regional setting inn System Preferences > International to set your default number and currency formats.

    Picture 7.png

     

    Brazil is a sub-set of Portuguese, found well down the list:

    Picture 6.png

    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.

     

    Regards,


    Barry

  • Badunit Level 6 Level 6 (10,765 points)

    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.

  • Barry Level 7 Level 7 (29,095 points)

    Hi BU,

     

    Thanks for stepping in with that clarification.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.