Formatting Issues

How to Display Full Values Instead of Millions Format in Excel

Ayan Masood Sep 27, 2026 869 views

Question details

The user wants to view the complete numeric value of a cell that is currently formatted to display as an abbreviated millions figure (e.g., 3.2 M €).

How to Display Full Values Instead of Millions Format in Excel

Product: Excel
Device & OS: not provided
Scenario: Reverting a custom number format to show full numbers for accurate reading, editing, or reporting.
Observed behavior: The cell visually displays a rounded or abbreviated number (like 3.2 M €) instead of the actual underlying numeric value (like 3,265,600).

Before you start

Verify that the true numeric value is still intact by clicking the cell and checking the formula bar; if the formula bar shows the full number, it is purely a formatting issue.

Solution 1Recommended

Apply the Standard Number or General Format

Change the custom cell format back to the default Number or General format to reveal the full underlying value.

Spreadsheet software uses custom formatting codes to abbreviate large numbers, making reports look cleaner. However, this only alters the visual display. By reverting the cell format to Standard or General, you force the application to display the complete number exactly as it was originally typed or calculated.

Select the target cells

Click and drag to highlight the specific cell or range of cells that are currently displaying the millions format.

Open the Format Cells dialog

Right-click the selected cells and choose 'Format Cells' from the context menu, or simply press the Ctrl+1 shortcut on your keyboard.

Choose the Number category

In the Format Cells window, navigate to the 'Number' tab. Under the Category list on the left side, select 'General' or 'Number'.

Apply the new format

If you selected 'Number', adjust the decimal places as needed. Click 'OK' to save your changes and display the full numerical values in your spreadsheet.

Apply the Standard Number or General Format

Underlying Data Remains Intact: Changing the format only affects how the number is visually presented on the spreadsheet. Your original data and calculation precision remain completely unchanged.

WPS Spreadsheet Solution

Easily Manage Number Formats with WPS Spreadsheet

WPS Spreadsheet offers an intuitive interface to seamlessly switch between custom millions formats and full numeric values. It handles large datasets efficiently while preserving your exact data precision.

1. Open your workbook: Launch WPS Office and open your spreadsheet file containing the abbreviated numbers.
2. Select the cells: Highlight the cells showing the millions format that you want to expand.
3. Modify the format: Go to the 'Home' tab, click the Number Format dropdown menu, and select 'General' or 'Number' to instantly reveal the full values.

Quickly toggle between General, Number, and Custom formats directly from the Home ribbon.Fully compatible with Microsoft Excel (.xlsx, .xls) formatting, ensuring no broken custom codes.Lightweight, fast, and completely free for everyday complex spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why does the formula bar show a different number than the cell?

The formula bar always displays the actual, underlying numeric value stored in the cell. The cell itself displays the value according to the specific number format applied to it, such as abbreviating it to millions.

Will changing the cell format affect my formulas or charts?

No. Spreadsheet formulas and charts always use the underlying numeric value for calculations and plotting. Changing the visual display format of a cell will not break or alter any calculations.

How do I create a millions format if I want to use it again?

You can recreate it by selecting the cell, pressing Ctrl+1 to open Format Cells, choosing 'Custom' under the Number tab, and typing a format code like 0.0,," M" to abbreviate large numbers.

Document & File Issues