Current location - Quotes Website - Signature design - How to set numbers to string display in excel
How to set numbers to string display in excel

You can use the function =TEXT(A1,"#"), which can be displayed as normal digits, but you need to be reminded that when the system changes your ID card to scientific notation, the ID card The last few digits of have all changed to 0, so even if the record form is restored, it is no longer the previous string of numbers, so it is recommended to set the cell format to "text" before inputting