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

Source: Internet
Author: User

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!

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.