How do I align numbers in different cells when some are in bracke.

  • Thread starter Thread starter Doogie
  • Start date Start date
D

Doogie

I trying to show both positive and negative numbers in a lsit. The negative
numbers are in brackets however this puts the numbers out of alignment with
each other. Is there away to ensure the numbers are aligned and the closing
bracket sitting outside the line of numbers.

Thanks
 
Custom format is:
" "#" ";"["#"]";" "#" ";@

The extra spaces will help align the numbers.
 
Use the "Accounting" format...
Format | Cells | Number (tab)
--
Jim Cone
Portland, Oregon USA
( Extras for Excel add-in... http://tinyurl.com/ExtrasForXL )



"Doogie" <[email protected]>
wrote in message I trying to show both positive and negative numbers in a lsit. The negative
numbers are in brackets however this puts the numbers out of alignment with
each other. Is there away to ensure the numbers are aligned and the closing
bracket sitting outside the line of numbers.

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

aligning by decimal point - negative and positive numbers 3
How do I align the figures when using brackets as a negative numbe 2
Negative number formatting 2
How to right-align text and numbers? 3
How do I center numbers in a cell, but align by decimal? 2
Lining up decimal points with negatives in brackets 2
How do I align the row numbers to top? 2
How to show brackets around a negative number 2

Back
Top