Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Alignment Question
Why am I unable sometimes to get numbers to right align properly. There seems
to be a gap to the right on numbers often? What causes this? like some will be completely flush right while others have a small gap after the last digital and the cell wall? Example: 9 l 9l They both are right aligned and sent to number? What would cause this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Alignment Question
Figured it out I need to use ().
"mjcxp" wrote: Why am I unable sometimes to get numbers to right align properly. There seems to be a gap to the right on numbers often? What causes this? like some will be completely flush right while others have a small gap after the last digital and the cell wall? Example: 9 l 9l They both are right aligned and sent to number? What would cause this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Alignment Question
It could be how you have it formatted if a negative number. If the cell is
formatted with parentheses when negative, there will be a 'hidden space' for it should the number become negative, whereas if you only have negative numbers in a different color (or with a preceding minus sign), then you shouldn't have the 'hidden space' and it should be flush to the right of the cell. -- John C "mjcxp" wrote: Why am I unable sometimes to get numbers to right align properly. There seems to be a gap to the right on numbers often? What causes this? like some will be completely flush right while others have a small gap after the last digital and the cell wall? Example: 9 l 9l They both are right aligned and sent to number? What would cause this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Question | New Users to Excel | |||
MS Excel number question | Excel Discussion (Misc queries) | |||
row number question in an array | Excel Worksheet Functions | |||
Need some help with alignment | Excel Discussion (Misc queries) | |||
Alignment | Excel Discussion (Misc queries) |