Right align positive and neg numbers using brackets around neg #s

T

Terri

How can I right align numbers in Excel but keep the right bracket of negative
numbers offset from the numbers?
 
J

Jacob Skaria

Do you mean the below..

Custom format the cells to
0.00_);(0.00)" "

If this post helps click Yes
 

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

add only positive numbers and avg in a column 6
Report Ignoring negative numbers 7
Formula nesting with IF statements 2
Excel If/Then's 6
FORMULA Sorts neg numbers as positive.. 2
Convert neg. numbers to positive numbers 10
show difference between weights with correct pos and neg values 2
How do I align numbers in different cells when some are in bracke. 2

Top