Add a number starting with "0" (zero) in Spreadsheets- Office Quick Tips 2

Method 1:  First input “ ' ”(Half-width single quotes), and then input the number;

Method 2:  Set the unit format as text, and then directly input the number starting with 0;

Both methods can be used according to our habits, but note that, once the content has been inputted, the value cannot be used in an operation, because these numbers are in text type, not operation format.