Input Really Long Numbers into Excel

Add to Favorites

How to input any length number in Excel and have it remain visible.

Excel truncates any number longer than 15 characters in length. This means that any number longer than that will have everything after 15 turned into zeros.

If you type: 1234567890123456789

Excel will change that to: 1234567890123450000

To keep your long number, type a single quotation mark/comma in front of the number. The new number would be input like this:

'1234567890123456789

You will only see the single quote when you double-click the cell to edit it.

Once you hit Enter, it will no longer be visible.

Notes

This method effectively changes your number into "text" as far as Excel is concerned. You will still be able to see this number but you won't be able to do much with it as far as mathematical operations are concerned.

Download the attached workbook to see this in Excel.


Downloadable Files: Excel File

Similar Content on TeachExcel
Store Large Numbers in Excel
Tutorial: I will show you how to display large, even huge, numbers in Excel.  In Excel, you can't s...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situati...
Keep Leading Zeros in Numbers in Excel - 2 Ways
Tutorial: I'll show you 2 ways to add and keep leading zeros in front of numbers in Excel. These t...
Basic Web Query in Excel - Import Data from the Web into Excel
Macro: Import data from the web into Excel with this macro. This is a basic web query macro that ...
Format Cells as a Scientific Number in Excel Number Formatting
Macro: This free Excel macro formats selected cells in the Scientific number format in Excel. Thi...
List All Files from a Directory into Excel
: Get a list of all files from a directory into an Excel worksheet. This allows you to navig...
Tutorial Details
Downloadable Files: Excel File
Similar Content
Store Large Numbers in Excel
Tutorial: I will show you how to display large, even huge, numbers in Excel.  In Excel, you can't s...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situati...
Keep Leading Zeros in Numbers in Excel - 2 Ways
Tutorial: I'll show you 2 ways to add and keep leading zeros in front of numbers in Excel. These t...
Excel Forum