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

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
 
L

Luke M

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

The extra spaces will help align the numbers.
 
J

Jim Cone

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
 
Top