BRACKETED NEGATIVE NUMBERS IN EXCEL

G

Guest

I have customised a number format in excel to bracket negative numbers.
However the numbers will not line up with the positive numbers in the same
column.

How do I change this? It is essential that they line up as I am producing
accounts for third parties.
 
J

JE McGimpsey

Take a look at "about custom formats" in XL Help, specifically spacing.
Including an underscore followed by a character causes the space
occupied by that character to be inserted, so one example would be:

Format/Cells/Number/Custom 0.00_);(0.00)

which would insert the width of a right paren after the positive number.
 
J

Jim Rech

If you want to skip custom number formats and have Excel include parened
negative numbers in its offerings, all you have to do is set the negative
number style of CURRENCY numbers under Windows Control Panel, Regional
Settings to use parens.

--
Jim Rech
Excel MVP
|I have customised a number format in excel to bracket negative numbers.
| However the numbers will not line up with the positive numbers in the same
| column.
|
| How do I change this? It is essential that they line up as I am producing
| accounts for third parties.
 

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

Red cell for negative numbers in Excel 1
count current run of positive numbers 6
Excel, change column of negative numbers to positive numbers? 3
Prevent negative numbers from changing to positive in calculation 1
How do I align numbers in different cells when some are in bracke. 2
negative number format 1
negative numbers to positive numbers in excel 3
Negative Numbers 8

Top