PeelstackWill it print?1:02 video

Why ZIP codes lose the leading zero in Google Sheets™ and the fix that works

ZIP code leading zero in Google Sheets™: type 02134 and the cell shows 2134. Setting the column to Plain text after the zero is lost does not bring it back. Format the column as Plain text before you type or paste, start the cell with an apostrophe, or use the TEXT function in another column. A custom number format only changes how the cell looks: the cell still holds the short number. Peelstack Label Maker prints what the cell shows and warns you when a ZIP code looks a digit short. Tested in Google Sheets™ on 2026-11-08.

Read more

Transcript

Type a ZIP code that starts with a zero, and Google Sheets drops the zero. Sheets reads it as a number, and numbers have no leading zeros. Fixing it afterwards does not work. Set the column to Plain text after the zero is lost, and it stays gone. Do it before. Format the column as Plain text first, then type or paste. Or start the cell with an apostrophe. Or use the TEXT function in another column. A custom number format only changes how the cell looks. Underneath, the cell still holds the short number, and a formula that compares it sees that. Peelstack Label Maker prints what the cell shows, and warns you when a ZIP code looks a digit short. Next: why labels drift down the page. Follow for more label tips. Taskivator.com slash peelstack.

Available nowGoogle Sheets™ and Google Docs™ add-on

Peelstack Label Maker