Google Sheets Custom Number Format: Zip Codes (so zip codes starting with 0 show the 0)

Published: 27 February 2018
on channel: DoIT Training at Stony Brook University
30,204
132

If you enter a 5-digit zip code that begins with a 0 in a Google Sheet cell, the first 0 will be trimmed off. Use custom number formats to force the beginning 0 to stay.


Watch video Google Sheets Custom Number Format: Zip Codes (so zip codes starting with 0 show the 0) online, duration hours minute second in high quality that is uploaded to the channel DoIT Training at Stony Brook University 27 February 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 30,204 times and liked it 132 visitors.