How I display negative amounts in parenthesis?

  • Thread starter Thread starter feribarra
  • Start date Start date
F

feribarra

I don't want the little dash in front of the amount to show it is negative. I
want the amount in parenthesis
 
Hi,

you may get away with
format|Cells|number and select the paren option from the dropdown.

If negative brackets are not available then it's over to Windows

Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative Currency Format. Click on drop-down
arrow
and select the ($1.1)

Repeat the above for number and it should then be in the Excel format dialog

Mike
 
Format>Cells>Number>Number>Negative Numbers.

You should have the option of bracketed negative numbers.


Gord Dibben MS Excel MVP
 

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 presentation 1
Negative Numbers 10
Help, how do I import a CSV file when Negatives are in Parenthesis 3
Negative Sum 1
How do I format a negative number in parenthesis? 10
Cause formulae totals to reflect negative and positive amount inpu 7
negative currency abbreviated format 1
Auto Insert Parenthesis 3

Back
Top