How to Display Long Numbers in Excel (4 Easy Methods)

 

Method 1 – Formating a Cell as Text to Display Long Numbers in Excel

STEPS:

  • Select the cells where you want to enter the long numbers. (Here, we have selected the range B6:D8.)

Format Cell as Text to Display Long Numbers in Excel

  • Press Ctrl + 1 to open the Format Cells box.
  • Go to the Number tab and select Text.
  • Click OK to proceed.

Format Cell as Text to Display Long Numbers in Excel

  • Select cell B6 and type a 12-digit number.
  • Press Enter.
  • You will see the 12-digit number and a warning sign. Don’t worry, it appears because a number is stored as text.

Format Cell as Text to Display Long Numbers in Excel

  • To remove the error, click on the warning sign. A drop-down menu will appear.
  • Select Ignore Error.

Format Cell as Text to Display Long Numbers in Excel

You will now be able to display long numbers in Excel.

Format Cell as Text to Display Long Numbers in Excel

You can follow the same steps to display 14/17-digit long numbers.

The full dataset will look like the picture below.

Read More: How to Enter 16 Digit Number in Excel


Method 2 –  Using a Single Quotation 

STEPS:

  • If you want to display 434556545415, select Cell B6 and enter the following:
'434556545415

Show Long Numbers Using Single Quotation in Excel

  • Press Enter to see results like the picture below.

Show Long Numbers Using Single Quotation in Excel

  • Click on the warning symbol and select Ignore Error from the drop-down menu.

Show Long Numbers Using Single Quotation in Excel

  • You can repeat the same steps to enter a 17-digit number like Cell D6.

You can display all the long numbers like the picture below.

Read More: How to Enter 20 Digit Number in Excel


Method 3 – Using the Excel TEXT Function 

STEPS:

  • Select Cell D6 and enter the following formula:
=TEXT(B6*C6,"0")

Use Excel TEXT Function to View Long Numbers

Inside the TEXT function, the first argument denotes the value, which is the product of Cell B6 & C6. The second argument denotes the number format. It means we are storing numbers as texts.

  • Press Enter and drag the Fill Handle down to copy the formula.

Use Excel TEXT Function to View Long Numbers


Method 4 – Using a Number Format 

STEPS:

  • Select the range B6:D8.

Use Number Format to Display Long Numbers with 15 Digits

  • Press Ctrl + 1 to open the Format Cells box.
  • Go to the Number tab and select Custom in the Format Cells box.
  • Type # in the Type field.
  • Click OK to proceed.

Use Number Format to Display Long Numbers with 15 Digits

  • Excel will display the long numbers.

Use Number Format to Display Long Numbers with 15 Digits


How to Display 16/20 Digit Numbers in Excel

STEPS:

  • Select Cell C5 and enter the 16-digit number below with a single quotation:
'2222333344445555

How to Display 16/20 Digit Numbers in Excel

  • Press Enter to see the result.

  • Repeat the same steps to type 20 and 22-digit long numbers.

How to Display 16/20 Digit Numbers in Excel

  • Select the range C5:C7 and click on the warning sign.
  • A drop-down menu will appear.
  • Select Ignore Error from there.

How to Display 16/20 Digit Numbers in Excel

  • You will be able to display 16/20-digit numbers in Excel.


Download the Practice Workbook

You can download the practice workbook from here.


Related Articles


<< Go Back to Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo