Tip: How to add leading zero for zip codes in Google Docs
JUNE 26, 2011
When Excel (or Google Docs) sees just numbers in a field, it assumes you want the field to be a number. But if you want to bring that spreadsheet to Google Docs, all that goes out the window because there’s no special setting in Google for zip codes. Sure, you can just wait until you do the final mail merge in Excel to format the zip column again, but here’s an easy way to have the zip codes display correctly in Google Docs and not worry about it later.