If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I align numbers in different cells when some are in bracke.
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 |
#2
|
|||
|
|||
How do I align numbers in different cells when some are in bracke.
Custom format is:
" "#" ";"["#"]";" "#" ";@ The extra spaces will help align the numbers. -- Best Regards, Luke M "Doogie" 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 |
#3
|
|||
|
|||
How do I align numbers in different cells when some are in bracke.
Use the "Accounting" format... Format | Cells | Number (tab) -- Jim Cone Portland, Oregon USA ( Extras for Excel add-in... http://tinyurl.com/ExtrasForXL ) "Doogie" 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 |
Thread Tools | |
Display Modes | |
|
|