Formatting Issues

How to Stop Excel Warnings for 16-Digit Numbers Stored as Text

Algirdas JasaitisAlgirdas Jasaitis Oct 28, 2026 871 views

Question details

The user wants to prevent the spreadsheet software from displaying error warnings when entering 16-digit identifiers as text, and stop the application from automatically changing the 16th digit to a zero.

How to Stop Excel Warnings for 16-Digit Numbers Stored as Text
Product
Microsoft Excel
Device & OS
not provided
Scenario
Entering 16-digit identifiers, such as credit card numbers, into a spreadsheet for record-keeping rather than mathematical calculations.
Observed behavior
The software flags the cells with a 'number stored as text' warning and automatically converts the 16th digit of numeric entries to zero, causing permanent data loss.
Before you start

Check your existing data to see if the 16th digit has already been changed to zero. If it has, the original value is lost, and you will need to re-enter the correct data after applying the proper text formatting.

Solution 1Recommended

Prefix with an Apostrophe or Use Separators

The quickest and most reliable method to force the software to treat a long numeric sequence as text without precision loss.

By default, spreadsheets have a 15-digit precision limit. Prefixing your entry or using separators ensures the value is interpreted as a text string from the moment it is entered.

1
Type a leading apostrophe

Select the target cell and type a single apostrophe (') before entering your 16-digit number. The apostrophe will not display in the cell but will force the text format.

2
Use visual separators

Alternatively, format the cell as Text and enter the number using spaces or dashes (e.g., 1234-5678-9012-3456), which is standard for credit card numbers and naturally prevents numeric conversion.

Prefix with an Apostrophe or Use Separators
Tip: If you already entered data and only changed the cell format afterward, you must re-enter the value or press F2 and Enter to apply the change.
Professional Spreadsheet Software

Easily Manage Long Numbers as Text in WPS Spreadsheet

WPS Spreadsheet provides a seamless, user-friendly interface for handling large datasets without unwanted data conversions. Easily format cells as text, import CSVs with precision, and manage error checking rules effortlessly.

  1. 1. Select your cells: Open WPS Spreadsheet and highlight the cells or columns where you plan to enter 16-digit identifiers.
  2. 2. Format as Text: Right-click the selected cells, choose 'Format Cells', and select 'Text' under the Number tab to prevent unwanted data conversion.
  3. 3. Manage Error Checking: To remove the green warning triangles, click the Menu icon > Options > Error Checking, and uncheck 'Number stored as text'.
100% compatible with Microsoft Excel file formats (.xlsx, .csv)Intuitive Text Import Wizard to prevent data loss on long identifiersAdvanced error-checking controls to customize or disable cell warningsLightweight, fast, and completely free to use for daily tasks
microsoft office alternative - wps office

Frequently Asked Questions

Why does the spreadsheet change the 16th digit of my credit card number to zero?

Most spreadsheet programs have a maximum precision limit of 15 significant digits for numeric values. Any number longer than 15 digits will have its subsequent digits automatically converted to zero unless the cell is properly formatted as text before data entry.

Can I recover the original 16th digit if it was already changed to a zero?

No. Once the software processes the 16-digit entry as a numeric value and converts the final digit to a zero, the original value is permanently lost from memory. You must re-enter the original data.

Does changing the cell format to Text fix numbers that are already entered?

Merely changing the cell format to Text does not change the underlying type of a value that has already been processed. After formatting the cell as Text, you must effectively re-enter the value by selecting the cell, pressing F2, and then pressing Enter.

How do I temporarily remove the green triangle without changing global settings?

You can ignore the warning on a case-by-case basis by selecting the affected cells, clicking the small yellow warning icon that appears next to them, and selecting 'Ignore Error' from the dropdown menu.