Formatting negative currency - doesn't have brackets

  • Thread starter Thread starter RobWN
  • Start date Start date
R

RobWN

xl03Pro
What dictates the available options in "format cells->currency"
At work (same version of xl) it has negative values as red with brackets whereas my home version
offers only red with a negative sign.
 
Excel picks this up from a windows setting:

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.
 
Thanks Dave.
All is well in my world.
I remembered the regional settings but only changed the number format (missed the currency
customization).
I always have trouble with things you do once in a blue moon-probably why I have a love/hate
relationship with this new machine!

Again, thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Negative Number Formatting Excel 2007 1
negative numbers 2
negative currency abbreviated format 1
Excel Excel 2010-how to display negative % with brackets 0
Number formats inconsistent 6
Negative numbers use braces 4
Negative amounts appear in brackets 3
Displaying negatives with (brackets) 3

Back
Top