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.

Table of Contents hide

Download Practice Workbook

3 Simple Ways to Enter 16 Digit Number in Excel

1. Converting Number to Text to Enter 16 Digit Number

2. Adding an Apostrophe Before Number

3. Applying Text to Columns to Enter 16 Digit Number

Practice Section

Conclusion

Download Practice Workbook

Enter 16 Digit Number.xlsx

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.

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.

It will be in the exact format in those cells.

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.

After that, press ENTER to have the output.

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

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.

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.

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.

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

Practice Section

For more expertise, you can practice here.

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.