How do I correctly display long strings of numbers in Excel?

Sometimes we enter a long list of numbers in an Excel table, but it doesn't work out, which is annoying, so how do we display these long strings of numbers "6217001630005541399"? The following small series for you to introduce, to see it!

Manually modify the number format

"1" Reason: Excel automatically converts long string numbers into scientific notation, and if you need to display growth string numbers, you must convert the data display format.

"2" Click to select the cell you want to modify, right-click, and select Format cell in the Options menu

"3" In the number item, the left menu select "Value" and the Right "decimal places" to 0, click OK.

Learn to use format brushes

The function of the "1" format brush is to convert all content into a uniform format, as shown in the following notation.

"2" click the correct format of the cell, and then click the Format Brush button, and finally click the cell you want to modify the format to complete the brush format operation, very convenient.

The format brush operation has a very wide application in daily form making and Word document making, which can save us a lot of time.

The above is how to correctly display a long string of digital methods in Excel, the operation is very simple, we have learned? Hope to be helpful to everyone!