Forum Discussion
Solved
The Alignment not working
Hi,
I select type the number format code as following
Column A: _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)
Column B: _(* #,##0.00%_);_(* (#,##0.00%);_(* "-"??_);_(@_)When I select Center Align, the content is not change, It is still in the right of column A and B
I expect the value is in the center of the column
Hope for your response
Thank you
littlevillage That's because these custom formats are, in fact, accounting formats lining up thousand separators and decimal points and currency symbols (if applicable). Removing the * signs in the formats will allow for centering, though.
Bear in mind, that centering such formats would render them useless and makes reports difficult to read. But, that's my personal opinion as an accountant.
littlevillage That's because these custom formats are, in fact, accounting formats lining up thousand separators and decimal points and currency symbols (if applicable). Removing the * signs in the formats will allow for centering, though.
Bear in mind, that centering such formats would render them useless and makes reports difficult to read. But, that's my personal opinion as an accountant.
