Fix Excel Center Alignment in Custom Number Formats
Question details
The user wants numbers to appear centered in Excel cells that use custom number formats.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Center alignment is applied to cells with an accounting-style custom number format.
- Observed behavior
- Numbers appear off-center because the format reserves or fills space around the displayed values.
Select an affected cell and open Format Cells to inspect its current number format. Note whether it displays currency, percentages, decimals, or special negative-number formatting before changing it.
Remove padding from the custom number format
Use this when accounting-style padding makes centered numbers look off-center.
Select the affected cells, right-click, and choose Format Cells. On the Number tab, select Custom and inspect the code in the Type box.
In the Type box, remove each asterisk and the character immediately following it; together they repeat that character to fill space. If underscore padding also causes unwanted spacing, remove the underscore and its following character. Preserve any symbols and number-format sections you still need.
Alternatively, enter #,##0 for whole numbers or #,##0.00 for two decimal places in the Type box. For values already intended as percentages, use a percentage format such as 0.00%.
In Format Cells, open the Alignment tab, set Horizontal to Center, and click OK. Check the displayed values in the selected cells.

Center numbers with custom formats in WPS Spreadsheet
Use WPS Spreadsheet to remove unwanted custom-format padding and center the displayed numbers in your cells.
- 1. Open the workbook: Open WPS Spreadsheet, choose Open, and select your Excel workbook.
- 2. Inspect the number format: Select the affected cells, right-click, and choose Format Cells. On the Number tab, select Custom and inspect the format code.
- 3. Remove padding: Remove unwanted asterisk fill codes and their following characters from the format code, or enter a suitable simpler format such as #,##0.00.
- 4. Center the cells: Open the Alignment tab in Format Cells, set horizontal alignment to Center, and click OK. Check that the values display as intended.

Frequently Asked Questions
Why do my Excel numbers look off-center even with Center selected?
The custom number format may contain asterisk fill codes or underscore spacing that adds space around the displayed value. Check the code under Format Cells > Number > Custom.
What does an asterisk do in a custom number format?
An asterisk repeats the character immediately after it to fill available space in the cell. Remove both the asterisk and that character from the Custom format code if the fill is unwanted.
Will changing the number format change the stored values?
No. Editing the format changes the display, not the stored values. However, formats can display values differently; for example, 0.00% displays 0.25 as 25.00%.
Can I keep currency symbols while removing padding?
Yes. In Format Cells > Number > Custom, remove only the unwanted fill or spacing codes and retain the currency symbol and any positive, negative, or zero format sections you need.




