Formatting Issues

Fix Excel Center Alignment in Custom Number Formats

Steven ParkerSteven Parker Nov 18, 2026 871 views

Question details

The user wants numbers to appear centered in Excel cells that use custom number formats.

Fix Excel Center Alignment in 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.
Before you start

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.

Solution 1Recommended

Remove padding from the custom number format

Use this when accounting-style padding makes centered numbers look off-center.

1
Inspect the format

Select the affected cells, right-click, and choose Format Cells. On the Number tab, select Custom and inspect the code in the Type box.

2
Remove fill codes

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.

3
Choose a simpler format if needed

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

4
Apply center alignment

In Format Cells, open the Alignment tab, set Horizontal to Center, and click OK. Check the displayed values in the selected cells.

Remove padding from the custom number format
Keep the intended number display: Changing a format affects how values are displayed, not their stored values. A percent format displays a value multiplied by 100, so use it only for values intended to be shown as percentages.
Work with spreadsheet formatting

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. 1. Open the workbook: Open WPS Spreadsheet, choose Open, and select your Excel workbook.
  2. 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. 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. 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.
Adjust custom number formats and cell alignment in one dialogCompatible with Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface to edit existing workbooks
microsoft office alternative - wps office

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.