The Alignment not working

[littlevillage]

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 

[#2 · Accepted solution]

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

[#3]

@Riny_van_Eekelen 

Thank you for your advising

It's worked

Best regards