How to Format Numbers with Leading Zeros in Google Sheets

0:00 You're looking to format numbers with leading zeros . This could be for a variety of reasons, something like tracking numbers, zip codes, order numbers, invoice numbers, anything like that. I'm going to show you how to format your numbers with leading zeros . Here with these tracking numbers, I'm going to select the entire column , click format Go to number , and then here on the right, we're going to scroll down to custom number format. Here there's zeros, there's even hashtags and commas, and you can put different types of symbols there. We're going to be putting zeros. In the case of tracking numbers, we want So we're going to have 1, 2, 3, 4, 5, 6, 7, and it'll show a sample right there. Click apply, and all of our numbers have three leading zeros here. in zip codes, we want five zeros, so we're going to go to format number, Add Zero in Front of Phone Number

0:47 custom number format , and put five zeros, 1, 2, 3, 4, 5, and again, it'll show a sample right here. Apply. For order numbers, maybe we only need four zeros, so we're going to go format number Custom number format for zeros. Click apply and invoice numbers as well. And go format number . Scroll down to custom number format . Maybe we want eight zeros. One, two, three, four. One, four. Apply. And the entire column has eight zeros. There's your leading zeros. No matter how many zeros you need at the beginning. Add Zero in Front of Phone Number