Formatting Issues

What Does ?? Mean in Excel Custom Number Formats?

Kushani Nimanthika Sep 30, 2026 868 views

Question details

The user wants to understand the function of the double question marks (??) used in the zero-value section of a custom Excel number format.

What Does ?? Mean in an Excel Custom Number Format?

Product: Excel
Device & OS: not provided
Scenario: Reading or modifying an advanced custom number format that aligns currency text, positive/negative digits, and zero values.
Observed behavior: The custom format includes _("$ "* "-"??_) for zero values, which attempts to perfectly align a dash with the decimal points of positive and negative numbers by using double question marks.

Before you start

To easily follow along, open the Format Cells dialog box in your spreadsheet (Ctrl+1) and ensure you have a sample dataset containing positive, negative, and zero values to observe the alignment effects in real-time.

Solution 1Recommended

Understanding the ?? Placeholder for Decimal Alignment

The ?? symbol acts as an alignment placeholder that reserves character spaces, ensuring that dashes or digits properly align with decimal points across an entire column of varying numbers.

In Excel custom formatting, the code is typically divided into four sections separated by semicolons: Positive; Negative; Zero; Text. Your specific zero-value section uses the double question marks.

The question mark (?) in Excel formatting is an optional digit placeholder. If a digit isn't present in that decimal place, Excel adds an invisible space instead. By using ?? in the zero-format section _("$ "* "-"??_), the format forces two blank spaces after the dash. This guarantees that the zero-value dash sits exactly where the whole numbers end, aligning perfectly with the two decimal places (,00 or .00) defined in the positive and negative sections.

Open Format Cells

Select the cells containing your financial or numerical data and press Ctrl+1 to open the Format Cells dialog box.

Navigate to Custom Formatting

Under the Number tab, scroll down and select 'Custom' from the Category list on the left side.

Apply and Observe the Format

Paste your custom format code into the 'Type' field and click OK. Notice how the ?? creates exact spacing for zeros, pushing the dash to align flawlessly with the commas or decimals in the numbers above and below it.

Understanding the ?? Placeholder for Decimal Alignment

Understanding Placeholder Syntax: Using a single ? reserves space for one character, while ?? reserves space for two characters. It is highly recommended to match the number of question marks to the number of decimal places used in your positive and negative format sections.

Master Formatting in WPS Spreadsheet

Effortlessly Manage Custom Formatting with WPS Spreadsheet

WPS Spreadsheet provides full compatibility with Microsoft Excel's custom number formats. You can effortlessly use advanced placeholders like ?? to beautifully align your financial data, fractions, and decimals without breaking formatting rules.

1. Download and Install: Download WPS Office from the official website and launch WPS Spreadsheet.
2. Select Your Data: Highlight the range of cells where you want to apply the custom currency or decimal layout.
3. Access Cell Formatting: Right-click the selected cells and choose 'Format Cells', or use the Ctrl+1 keyboard shortcut.
4. Apply Custom Code: Select the 'Custom' category and input your format code containing the ?? placeholders to perfectly align your decimals and dashes.

100% compatible with Microsoft Excel (.xlsx) files and custom format syntaxes.Seamlessly handles advanced cell formatting, conditional formatting, and formula integration.Lightweight software with a familiar, easy-to-navigate tabbed interface.Completely free to use for everyday data analysis, alignment, and formatting needs.

Frequently Asked Questions

What is the difference between 0, #, and ? in Excel custom formats?

The '0' placeholder forces a digit to display, adding insignificant zeros if necessary. The '#' placeholder only displays significant digits and drops extra zeros. The '?' works exactly like '#', but adds a blank space for any insignificant zeros, which ensures decimals remain perfectly aligned in a column.

Can I use ?? for formatting fractions?

Yes, question marks are frequently used for properly aligning fractions. Applying a custom format like '# ??/??' allows fractions with up to two digits in the numerator and denominator to align correctly along the slash mark in a vertical column.

Why are there four sections separated by semicolons in custom formats?

Excel custom number formats can contain up to four distinct sections separated by semicolons to define how different data types are displayed. The sequence is strictly defined as: Positive values; Negative values; Zero values; Text values.

How do I remove a custom format if it breaks my layout?

Select the affected cells, press Ctrl+1 to open the Format Cells menu, navigate to the Number tab, and select 'General' from the list. This will clear the custom formatting rule and return your data to its default unformatted state.

Document & File Issues