Using Leading Zeros in Numbers

If you wish to represent a number in a cell with leading zeros, such as a zip code that starts with a 0 digit, or an International phone number, then you can do it using the Text cell format which treats the number as a series of characters, rather than a value. You can also use custom cell formatting to display a number with leading zeros, which can help you if you wish to have easy data entry and uniform cell formatting.