How to Keep Leading Zeros in Google Sheets

In this video, I show how to keep leading zeros in Google Sheets. I cover three different ways to keep leading zeros in your spreadsheet.

Read through the full tutorial here:

Timestamps:
00:00 Intro
00:33 Adding an Apostrophe Before the Number
1:36 Text Format to Keep Leading Zeros
2:21 Custom Number Format

[donailyn]

Thank you! something so simple that can make such a huge difference.

[CarbonatedTurtle]

Do you have any idea how I can make this work for numbers inside of a formula? I was really hoping one of them might, but unfortunately none of them do.

[FistechMBC]

Keeping leading zeros from a google form to google result spreadsheet

[ColinMcNulty]

So let me get that right, to format something as Text, you have click: "Format | Number"... 🤔 I can't imagine why I didn't work that out myself! 😆 Bloody Google