Excel Long Number Format: Display More Digits Correctly

How-to basics · Updated November 19, 2026

In Excel, a long number format changes how a value is displayed, not how many digits Excel can store accurately. To display a number without scientific notation, widen the column or choose a suitable number format; if the value is an identifier longer than 15 significant digits, store it as text before entering or importing it, because formatting cannot recover digits Excel has already changed.

What Excel Means by a Long Number Format

Excel does not have one special setting called a long number format. The phrase usually refers to a number format that shows a long value in a readable way—for example, with all available digits, grouped thousands, a fixed number of decimal places, or leading zeros. The right choice depends on whether the cell contains a quantity you calculate with or a string of digits used as an identifier.

Excel normally uses the General format. Depending on the value and the column width, General may show a long number in scientific notation, such as 1.23E+15, or display fewer decimal places than the stored value. Those are display choices; they do not automatically mean the cell’s underlying value changed. Click the cell and look at the formula bar to inspect its value, while remembering that the formula bar cannot reveal digits that Excel discarded during entry.

What Number Formatting Changes

A number format tells Excel how to present a numeric value. It can add separators, set the displayed decimal places, show a currency symbol, or pad a value with zeros. It does not change the underlying number used in calculations. For example, a cell containing 1234.5 can display as 1,234.50 with a suitable format, while its value remains 1234.5.

Displayed rounding is also different from changing the value. If you format 12.345 to show two decimal places, the cell may display 12.35, but a calculation can still use the stored value 12.345. A format is therefore not a reliable way to round data for calculations. Use a rounding function or change the underlying value when the calculation itself must use a rounded amount.

How to Show a Long Number in Excel

For a numeric value that Excel has retained accurately, try these steps in Excel for Microsoft 365 on Windows:

  1. Select the cell or range containing the number.
  2. Widen the column by dragging the right edge of its heading, or double-click that edge to AutoFit it to the contents.
  3. On the Home tab, open the Number Format drop-down in the Number group and choose Number, or select More Number Formats to open the Format Cells dialog.
  4. In Format Cells, choose Number and set the decimal places and thousands separator as needed. Select OK to apply the format.

You can also select the cells and press Ctrl+1 on Windows to open Format Cells. On a Mac, Command+1 is the usual equivalent. The ribbon layout can differ on Mac and in Excel for the web, but the underlying principle is the same: choose a number style that makes the value readable. For a simple long integer, a format such as #,##0 adds thousands separators without displaying decimal places. If digits still do not appear after widening the column, check whether Excel is displaying scientific notation or whether the value was already altered when entered.

Useful Custom Number Formats

When the built-in choices do not give the display you want, create a custom format. In the Format Cells dialog, select Custom and enter a format code in the Type box. These examples are useful starting points:

  • #,##0 displays a whole number with thousands separators, such as 1234567 as 1,234,567.
  • #,##0.00 displays two decimal places and thousands separators, such as 1234.5 as 1,234.50.
  • 000000 displays at least six digits by adding leading zeros, so the numeric value 123 appears as 000123.
  • 0.00E+00 displays a number in scientific notation with two decimal places in the mantissa.

In a custom format, the zero symbol requires a digit in that position, while the number sign can leave an unnecessary position blank. That is why 000000 pads with zeros, whereas ###### does not. These formats affect appearance only: a six-zero format does not turn a value into a six-character text string or preserve a leading zero as part of its stored numeric value. If an ID must retain its exact spelling, including zeros, keep it as text.

Scientific Notation and Column Width

Scientific notation is a compact way to represent very large or very small numbers. For example, 1.2E+08 means 1.2 multiplied by 10 to the eighth power, or 120,000,000. Excel may show this when a cell is too narrow or when the General format chooses a compact representation. Widening the column or applying a suitable number format often makes an ordinary numeric value easier to read.

Scientific notation is not the same as data loss. A value that appears as 1.23E+15 may still contain more digits than are visible in the cell. Select the cell, widen the column, and apply a format such as 0 or #,##0 to inspect the display. But do not assume that a format can reveal the original digits of a value that exceeded Excel’s precision limit when it was entered.

The 15-Digit Precision Limit

Excel preserves up to 15 significant decimal digits for numeric values. Significant digits are the meaningful digits in a number, not simply the digits after the decimal point. When a number with more than 15 significant digits is entered as a number, Excel changes digits beyond that precision—commonly replacing later digits with zeros. A custom format can make the resulting value look longer, but it cannot restore the original digits.

This distinction matters most for long identifiers, such as bank account references, product codes, tracking numbers, and some credit-card or scientific instrument values. They may contain many digits but are not quantities you need to add or average. Treating them as numbers can both remove precision and make arithmetic or sorting behave in ways that are not appropriate for an ID. A 16- or 18-digit identifier should generally be stored as text if every digit must remain exact.

For measurements or financial values, consider whether the value genuinely needs more than 15 significant digits. Excel may be appropriate for ordinary calculations, but a number format is not a way to increase numeric precision. If exact high-precision arithmetic is essential, use a system designed for that requirement and check that data transfers preserve the intended values.

Keeping Long IDs and Leading Zeros

To preserve a long digit string, set the destination cells to Text before typing or pasting the values. Select the cells, open the Number Format drop-down on the Home tab, and choose Text; then enter or paste the IDs. You can also type an apostrophe before a value, such as '001234567890123456. Excel uses the apostrophe to treat the entry as text, and it does not appear as part of the displayed cell content.

If an ID was already entered as a number and Excel replaced digits, changing the format to Text afterward does not reconstruct the original. You need to obtain the original value again from the source and import or enter it as text. The same is true of leading zeros: formatting a numeric 123 as 00000 can display 00123, but it cannot tell Excel whether the intended original ID had five digits, six digits, or another length. Use text when the exact character sequence matters.

Importing Long Numbers from CSV or Other Sources

Importing is a common point where long values are unintentionally converted. A CSV file does not preserve Excel cell formats; it contains text separated by delimiters. When Excel opens a CSV directly, it may infer that a long digit string is numeric and apply its precision limit. If exact digits matter, avoid relying on automatic conversion.

In Excel for Microsoft 365 on Windows, use Data > From Text/CSV to preview the file before loading it. For greater control, choose Transform Data to open Power Query, select the column, and set its data type to Text before loading the data to the worksheet. Confirm that the preview retains all digits and leading zeros. Menu labels and options can differ slightly across versions, but the key is to assign the column a text type before Excel interprets the value as a number.

When receiving a workbook rather than a CSV, check the source cell’s type and value before using it. If the source application has already converted an identifier to a number with fewer than the original digits, Excel cannot infer what those missing digits were. Request a text-preserving export from the source system if exact identifiers are important.

Common Problems and How to Diagnose Them

  • The cell shows E+ notation: Widen the column and try a standard or custom number format. If the full value still cannot be recovered, check the original source.
  • Zeros at the start disappear: The entry is probably numeric. Re-enter or re-import it as text, or use a fixed-width custom format only if the zeros are purely for display.
  • Changing to Text does not fix the digits: The numeric value may already have lost precision. Re-import the original data as text rather than changing the existing cell format.
  • Displayed decimals look rounded: Increase the displayed decimal places to inspect them. Remember that the existing value may have more precision than the cell shows.
  • Sorting or calculations behave unexpectedly: Text values and numeric values sort and calculate differently. Keep actual quantities numeric, and keep identifiers as text; do not convert IDs to numbers just to make them look consistent.

Frequently Asked Questions

How do I make Excel show all digits instead of E+ notation?
Widen the column, then apply a number format such as 0 or #,##0. This can reveal digits that were hidden by the display, but it cannot restore digits already changed because of Excel’s 15-significant-digit limit.

Can Excel store a 16-digit number accurately?
Not as a numeric value with all 16 significant digits. Excel preserves up to 15 significant digits, so store the value as text if every digit is essential.

Does changing the cell format to Text recover lost digits?
No. Changing the format affects how Excel treats the cell going forward, but it cannot undo precision loss that happened when the number was originally entered or imported. Retrieve the original value and bring it into Excel as text.

How can I add leading zeros to a number?
For display only, use a custom format such as 00000 to show a value like 123 as 00123. If the zeros are part of an exact code or ID, store the entire entry as text instead.

Should long numbers be stored as text or as numbers?
Store quantities that you need to calculate with as numbers, provided their required precision is within Excel’s limits. Store identifiers, codes, and digit strings whose exact characters matter as text.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.