Shulou(Shulou.com)05/31 Report--

What if the ID number of excel is changed to 0? When using excel, many children's shoes will encounter the phenomenon of excel input number garbled, especially the phenomenon that excel input ID number becomes 0 is the most common; the following editor will teach you how to do it.

What if the ID number is changed to 0 by excel:

The reason is that Excel currently supports up to 15 digits, and all numbers exceeding it default to "0". The solution is simple: change the format from "numeric" to "text". Because the ID card number as a series of fixed numbers has no operational requirements, it should belong to the well-behaved text.

Method 1: first enter the "'" sign of the English half-corner in the table (the key after the colon), and its function is to change the attribute of the table item to "text".

Method 2: if you can't remember which symbol to enter first, there is a more general way to drop down the formatting list in the Toolbar and click on the text at the bottom.

Method 3: right-click the selected cell, select "format the cell", select "text" in the "number" tab and click OK.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.