How can I add a zero (0) to a zip code as the first number when using Numbers version 10.3.5 (7029.5.5)?

Start your entry with an apostrophe. This tells Numbers that what follows is to be treated as text.

'01111 will display as 011

Regards,

Barry

Pre-format the cell/column/row as text before entering anything. Everything you enter will be treated as text, including numbers, and it will not remove leading zeros. Same idea as using the leading apostrophe but more convenient if you are doing this in a column of cells or often changing the value in a single cell.

In addition to Barry’s suggestion, one can also Create [a] Custom Format, such as for all the Cells where you may have zip codes. Instead of using # symbols, you would use zeros (0s).

If you use a custom number format instead of text, one that allows both 5 and 9 digit zips might look like the one below. You do not type a dash when entering 9-digit zips, just the 9 digits. If there are any ZIPs that begin with four leading zeros (as in 00001-1234), this format won't work. Are there any?

Hi Kodiak,

Set the cell data format to Numeral System, Base 10, with the necessary number of places

Regards,

Ian.