Formatting Issues

How to Align Positive and Negative Percentages in Excel

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to align positive and negative percentages at the decimal point, with negative values formatted in red and enclosed in parentheses.

Product: Excel
Device & OS: not provided
Scenario: Formatting financial or statistical spreadsheet data where negative percentages are indicated by parentheses, requiring precise decimal alignment.
Observed behavior: Positive and negative percentage values fail to align properly at the decimal point because the parentheses added to negative numbers take up extra space, throwing off the layout when decimal lengths vary.

Before you start

Highlight the specific column or range of cells containing your percentage data before applying the custom number formatting.

Solution 1Recommended

Apply Custom Number Formatting with Space Reservation

Use a custom format code to reserve space for positive numbers so they align perfectly with negative numbers wrapped in parentheses.

By default, adding parentheses around a negative number shifts its decimal point to the left. To fix this, you must apply a custom format that reserves an invisible space for the parenthesis at the end of positive values.

Select Cells

Highlight all the cells containing the percentage values you wish to format.

Open Format Cells

Right-click the selected area and choose 'Format Cells', or press the shortcut 'Ctrl + 1' on your keyboard.

Navigate to Custom Category

In the Format Cells dialog, click on the 'Number' tab and select 'Custom' from the Category list on the left.

Enter the Format Code

In the 'Type' input box, enter the custom format code: _(#,##0.0%);[Red](#,##0.0%). Adjust the '0.0' portion to match your desired number of decimal places.

Apply Formatting

Click 'OK' to save the changes. Your positive and negative percentages should now align at the decimal point.

Fixed Decimal Requirement: Because the number of decimal places determines the exact spacing, use a consistent decimal length (e.g., one or two decimal places) across all cells for perfect alignment.

Solution 2

Disable Wrap Text to Prevent Misalignment

Disable the Wrap Text feature, which can sometimes interfere with precise character spacing and custom number alignments.

Professional Formatting Tool

Easily Format and Align Percentages with WPS Spreadsheet

WPS Spreadsheet provides powerful custom cell formatting features, allowing you to perfectly align positive and negative percentages with just a few clicks.

1. Open Your File: Launch WPS Spreadsheet and open the document containing your data.
2. Select Data: Highlight the cells with the percentages you want to format.
3. Access Format Cells: Right-click and select 'Format Cells', or press Ctrl+1.
4. Apply Custom Format: Go to the 'Number' tab, select 'Custom', and input _(#,##0.0%);[Red](#,##0.0%).
5. Confirm and Save: Click 'OK' to align the decimal points of positive and negative percentages perfectly.

Fully compatible with Microsoft Excel custom formatting codes.Easily format negative values in red with parentheses.Lightweight software with a familiar, easy-to-navigate interface.Free to use for everyday data analysis and formatting.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my positive and negative percentages still not align after using the custom format?

This usually happens if the 'Wrap Text' feature is enabled on those cells, or if you are using a proportionally spaced font instead of a standard uniform font. Ensure 'Wrap Text' is disabled in the Home tab and try a standard font like Arial or Calibri.

How do I align percentages with a varying number of decimal places?

Aligning values with varying decimal places is very difficult because the physical length of the number shifts the decimal point. To achieve perfect alignment, it is best to use a fixed number of decimal places in your custom format, such as 0.00%, so all values occupy the exact same amount of space.

Can I change the color of the negative percentages in the custom format?

Yes. In the custom format code _(#,##0.0%);[Red](#,##0.0%), you can replace the [Red] tag with other standard color codes like [Blue], [Green], or [Cyan] to match your document's visual design.

Excel & Data Problems