How to Enter 16 Digit Number in Excel (3 Simple Ways)

Get FREE Advanced Excel Exercises with Solutions!

Microsoft Excel is used to store data in a tabular format and to perform calculations on that data. We might need to input data with 16 digit number. Often it converts in scientific form. In this article, I am going to show 3 simple ways on the topic of how to enter 16 digit number in Excel. I hope it will be helpful for you.

For more clarification, I am going to use a dataset of Argentine Football Players’ salaries in club football. I have organized data in the Name, Team, Salary, and Account Number columns.

How to Enter 16 Digit Number in Excel


Download Practice Workbook


3 Simple Ways to Enter 16 Digit Number in Excel

1. Converting Number to Text to Enter 16 Digit Number

In order to enter 16 digit number in Excel, changing the input format to Text is a very simple way. You just need to follow the following procedure to do so.

Steps:

  • First of all, select the cells where you want to enter the 16 digit number. I have selected cells C5:C9 for this purpose.

Converting Number to Text to Enter 16 Digit Number

  • Next, go to the Home tab.
  • After that, click on the Number Format extension button from the ribbon.
  • From the available options, select the Text option.

  • Now, write your 16-digit numbers on those cells.

Converting Number to Text to Enter 16 Digit Number

It will be in the exact format in those cells.

Read More: How to Display Long Numbers in Excel (4 Easy Ways)


2. Adding an Apostrophe Before Number

The simplest way to enter a 16 digit number in Excel is to add an Apostrophe sign (‘) in front of the number. I have explained it in the following section.

Steps:

  • Insert the Apostrophe sign first.
  • Then, input the number.

Adding an Apostrophe Before Number

  • After that, press ENTER to have the output.

  • Use a similar process to enter all the 16 digit numbers.

Read More: How to Add Currency Symbol in Excel (6 Ways)


Similar Readings


3. Applying Text to Columns to Enter 16 Digit Number

Text to Columns is another feature that we can use to enter 16 digit number. In this process, the selected cells in a column will turn into text format and 16 digit number will easily access to those cells.

Steps:

  • Select the cells in a column where 16 digit numbers are already input.
  • Go to the Data tab after that.
  • Pick Text to Columns from the ribbon.

Applying Text to Columns to Enter 16 Digit Number

The Convert Text to Columns Wizard will appear.

  • Select Delimited – Characters such as commas or tabs separate each field.
  • Click on the Next button.

  • Along with that, check the Tab box from Delimiters.
  • Press Next.

Applying Text to Columns to Enter 16 Digit Number

  • Finally, select the Text option from Column data format and hit the Finish button to end the process.

We can see the 16 digit number on the selected cells.

Applying Text to Columns to Enter 16 Digit Number

Note: These methods are not only applicable for 16 digit number but also you can enter 20 digit number using these.

Read More: Excel Number Stored As Text [4 Fixes]


Practice Section

For more expertise, you can practice here.

For Practice


Conclusion

That’s all for today. I have tried to show 3 simple ways on the topic of how to enter 16 digit number in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo