add the formatting to the whole worksheet column - not just the table. Unfortunately that didn't help.
Format the cells in the Table as Accounting, Then format the cells below the table as Accounting.