Forum Discussion

littlevillage's avatar
littlevillage
Iron Contributor
Sep 03, 2022
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 Ce...
  • Riny_van_Eekelen's avatar
    Sep 03, 2022

    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.

Resources