Skip to content
knowsheets.com
  • Categories
    • About Google Sheets
    • All About Formulas
    • Formatting Sheets
    • Using Buttons in Sheets
    • Apps Script Examples
    • Templates & Examples
  • About Us
  • Contact Us
  • Privacy Policy

knowsheets.com

  • Categories
    • About Google Sheets
    • All About Formulas
    • Formatting Sheets
    • Using Buttons in Sheets
    • Apps Script Examples
    • Templates & Examples
  • About Us
  • Contact Us
  • Privacy Policy

custom number formats

Working with Zip Code Format in Google Sheets

November 23, 2022November 23, 2022 by Dave
Zip code data in Google Sheets

Are you working with zip code data in your Google Sheet? If you’ve imported some 5 digit zip code data and lost the leading zeros from certain states like Connecticut, Massachusetts, Puerto Rico, and New Jersey, I’ll show you several easy ways to put it back. If you need to import zip code data and … Read more

Tags custom number formats, Formatting, leading zeros Leave a comment

Restoring Missing Leading Zeros in Google Sheets

November 23, 2022November 22, 2022 by Dave
3 ways to restore leading zeros

When you import data into Google Sheets using copy and paste, unless you format the destination cells as Plain Text, sheets will convert your data into numbers and lose the leading zeros. 0000123 will become 123. This will also happen if you leave the Convert to numbers option ticked during a file import. Read our … Read more

Tags custom number formats, Formatting, leading zeros Leave a comment

How to Keep Leading Zeros in Google Sheets Data

November 22, 2022 by Dave

If a 7 digit fixed width field contains a number less than 1 million, that number will normally have leading zeros, i.e. 0001234 (the 000 at the start being the leading zeros). A problem can arise in Google Sheets sometimes because without proper consideration, leading zero numbers can get formatted as regular numbers and 0000124 … Read more

Tags custom number formats, Formatting, leading zeros Leave a comment
  • TikTok
  • Facebook
  • Instagram
  • YouTube
Copyright © 2025 knowsheets.com