Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
align row numbers with row data | Setting up and Configuration of Excel | |||
How do I align the row numbers to top? | Excel Discussion (Misc queries) | |||
how do i align numbers | Excel Discussion (Misc queries) | |||
Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
Numbers won't right-align | New Users to Excel |