Thursday, January 31, 2019

Google Sheets: Keep the 0 in Front!

Have you ever found yourself entering numbers into Google Sheets that begin with 0 and when you click out of the cell the 0 disappears?

To keep the number exactly as typed (with the 0 at the beginning) simply precede the number with an apostrophe (').  
It changes the number into a text value (so you can't do math with it), but it is very useful when typing Cumberland's zip code (04021)!


When you click off the cell, the apostrophe doesn't show and the leading 0 stays put!