How I display negative amounts in parenthesis?

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
 
M

Mike H

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
 
G

Gord Dibben

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

Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Negative value to positive 13
Creating a Chart on form from selected data in query. 0
negative currency abbreviated format 1
Help, how do I import a CSV file when Negatives are in Parenthesis 3
negative number presentation 1
Negative Numbers 10
Auto Insert Parenthesis 3

Top