Excel can store numeric values with up to 15 significant digits, but that is not the same as a fixed limit on how many digits a cell can display. A number format controls the visible decimal places and other presentation details; it cannot add precision to a value Excel has already stored.
Excel’s 15-digit precision limit
For ordinary numeric values, Excel keeps 15 significant digits of precision. Significant digits begin with the first nonzero digit and include the digits that follow it, not simply the digits after a decimal point. For example, 123,456,789,012,345 has 15 significant digits. So does 0.000123456789012345: its leading zeros do not count toward the 15.
If you enter a number with more than 15 significant digits, Excel changes digits after the fifteenth to zeros when it stores the value. For instance, entering 12345678901234567 as a number results in a stored value of 12345678901234500. A cell may show the result in scientific notation when the full value does not fit, but changing the display format will not bring back the discarded digits.
This limit applies to the value, not to the total characters that can appear on screen. A number format can add commas, a currency symbol, a percent sign, or trailing zeros. Those characters affect how the value looks, not how much numeric detail Excel retains.
Displayed digits and stored digits are different
A cell can display fewer decimal places than its underlying value. If A1 contains 12.34567 and its format shows two decimal places, the cell displays 12.35 while the underlying value remains 12.34567. Formulas that refer to A1 generally use the stored value, not the rounded-looking display.
The reverse can happen too: a format can display extra decimal places, often as zeros. If a value is 1.2 and the format is set to three decimal places, Excel can show 1.200. That does not mean the original measurement was accurate to three decimal places. It is only a presentation choice.
When a number does not fit in the visible column, Excel may show hash marks, such as ####, rather than the value. This usually means the column is too narrow for the formatted result, particularly for dates and times. Widen the column or choose a shorter number format; the hash marks do not indicate that the cell has exceeded the 15-digit precision limit.
How to change the number of decimal places
In Excel for Microsoft 365 on Windows, select the cells, then use Home > Number to choose a common format or adjust decimal places. The Increase Decimal and Decrease Decimal buttons change how many decimal places are displayed. For more control, open the Format Cells dialog with Ctrl+1, select the Number category, and set Decimal places.
On a Mac, Command+1 opens Format Cells. The ribbon also has number-format controls on the Home tab, though their layout can differ from Windows. In Excel for the web, use the number-format controls on the Home tab; some detailed formatting options may be arranged differently from the desktop dialog.
For example, suppose a cell contains 8.2764. Setting its display to two decimal places shows 8.28, while setting it to four shows 8.2764. These settings do not change the number used in calculations. If the value needs to be numerically rounded for later calculations or reporting, use a rounding function instead of relying only on its appearance.
Custom formats for controlling visible digits
Excel’s custom number formats use placeholders to specify how numbers appear. Open Format Cells with Ctrl+1 on Windows, select Custom, and enter a format code. The most useful placeholders are:
0displays a digit, adding a zero when needed. The format0.00displays two decimal places, including trailing zeros.#displays a digit only when one is present. The format0.##can show up to two decimal places without forcing trailing zeros.?reserves space for a digit or a blank, which can help line up decimal points in a column.
For example, the format #,##0.00 displays a number with thousands separators and two decimal places, such as 12345.6 as 12,345.60. It still does not make the value more precise. A format such as 0.00E+00 displays a number in scientific notation, which is useful when values are very large or small. Custom formats can make a long value easier to read, but they cannot defeat Excel’s precision limit.
Long numbers, account codes, and leading zeros
Not every digit-heavy entry should be treated as a number. Phone numbers, tracking codes, product IDs, and account numbers are identifiers: people may compare or search them, but rarely add or average them. Store these entries as text, especially if they exceed 15 significant digits or begin with zero.
For a single entry, type an apostrophe before the digits, such as '001234567890123456. Excel uses the apostrophe to signal text and does not display it as part of the cell value. For a column of entries, select the column and set its format to Text before typing or pasting the data. When importing a file, use Data > From Text/CSV and set the relevant column to Text in the import process, so Excel does not first interpret a long identifier as a number.
A custom format such as 00000 can make the number 42 appear as 00042, which is convenient for fixed-width codes. But those zeros are only a display effect: the cell still contains the numeric value 42. If the leading zeros are part of the identifier itself, text is usually the safer representation. If Excel has already replaced digits beyond the fifteenth with zeros, changing the cell to Text afterward cannot restore the original digits; retrieve the original value from its source and import it as text.
When to use rounding instead of formatting
Use a number format when the goal is simply to make a worksheet easier to read. Use a rounding formula when later calculations should use a rounded value. For example, with 12.346 in cell A2, enter =ROUND(A2,2) in another cell. The result is 12.35. The original value in A2 remains unchanged, while the formula result is a new numeric value rounded to two decimal places.
This distinction matters in totals, measurements, and reports. If each line item must be rounded before being added, round each item first and sum those results. If only the final total should be rounded, add the unrounded values and round the total. Those approaches can produce different answers, so follow the rules used by the relevant business process or reporting specification rather than assuming the display setting determines the calculation.
Rounding also cannot recover detail that was never captured. If a measurement is entered as 1.2, formatting it to show 1.200 does not make it equivalent to a measurement recorded as 1.200. Keep the original source data when precision matters, and make any rounding step explicit in the worksheet.
Floating-point calculations and precision settings
Excel stores numeric values using binary floating-point arithmetic. Many decimal fractions, including 0.1, do not have an exact finite representation in binary, so calculations can sometimes produce tiny differences from the decimal result someone expects. The 15-significant-digit rule is a practical limit on numeric precision; it does not mean every calculation will match an exact decimal-arithmetic system in every last digit.
For most everyday spreadsheets, this is not noticeable. It can matter in repeated calculations or when comparing calculated values for exact equality. A sensible approach is to round at a clearly defined point when the task requires it, rather than hiding small differences by changing the display format.
Excel for Windows also has a workbook setting called Set precision as displayed, under File > Options > Advanced, in the calculation options for the workbook. It makes stored values match their displayed precision, which can permanently discard digits hidden by a cell’s format. Use it only when that irreversible change is intended, and save a backup first. Usually, adjusting the display or using an explicit rounding formula is safer.
Scientific notation, percentages, and dates
Scientific notation is a display format, not a separate way to increase precision. A value such as 123456789012345 may be displayed in a form like 1.23457E+14, depending on the cell format and column width. Showing more digits in scientific notation still cannot restore digits beyond Excel’s stored precision. Widening the column or selecting a different format may make the value easier to inspect.
Percentage formatting also changes the display convention: it shows a value multiplied by 100 and adds a percent sign. A stored value of 0.25 displayed as a percentage appears as 25%. The underlying value remains 0.25, and the format does not round it for calculations. Dates and times are likewise numeric values shown with date or time formats. A date format changes what the serial value looks like, not the number of significant digits Excel can store.
Frequently Asked Questions
Does Excel have a 15-digit limit or a 15-decimal-place limit?
It is a 15-significant-digit precision limit for numeric values, not a limit of 15 digits after the decimal point. Leading zeros do not count as significant digits, so the number’s scale affects how those 15 digits are distributed.
Why does Excel turn the last digits of my long number into zeros?
Excel is treating the entry as a number and retaining only 15 significant digits. Digits after that are changed to zeros. If the value is an identifier, re-import or re-enter the original data as text; formatting the altered number as text cannot recover the lost digits.
Can I make Excel display more than 15 digits?
You can choose a format that shows more places or use text to preserve a long sequence of digits. However, a numeric value cannot gain reliable precision beyond Excel’s 15-significant-digit limit. For exact long identifiers, store the sequence as text rather than as a number.
Does changing decimal places round the value?
No. Changing decimal places normally changes only the display. The stored value remains available to formulas. To create a rounded numeric result, use a function such as ROUND and refer to that result where appropriate.
Why does Excel show #### instead of my number?
The formatted result often does not fit in the column, especially for dates, times, or large values. Widen the column or choose a shorter format. Hash marks alone do not show that Excel has lost precision.
Related
- Excel Dependent Drop-Down List: 3 Levels
- Excel Date Number to Text: Convert Dates Clearly
- Excel Data Validation List: Create a Yes/No Dropdown
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add Page Numbers in Word: Step-by-Step GuideTo add page numbers in a Word document, open the file, select Insert > Page Number, choose a…
- How to Add a Citation in Word: A Step-by-Step GuideTo add a citation in Microsoft Word, place the cursor where the citation belongs, open References > Insert…
- Remove a Page Break in Excel: Manual and AutomaticTo remove a manual page break in Excel for Microsoft 365 on Windows, select the cell immediately below…
- Percentage of a Number in Excel: How to Calculate ItTo find a percentage of a number in Excel, multiply the number by the percentage. For example, with…
- Excel Data Validation: Create Rules and Drop-Down ListsTo validate entries in Excel for Microsoft 365 on Windows, select the cells, choose Data > Data Validation…
- Track Changes Options in Microsoft Word: Where to Find ThemTo get to Track Changes options in Microsoft Word for Microsoft 365 on Windows, open the document, select…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.