The Alignment not working

Frequent Contributor


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 

2 Replies
best response confirmed by small_village (Frequent Contributor)

@small_village 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.


Thank you for your advising

It's worked

Best regards