Topic A: Using special number formats - leading zeros

The keyboard shortcut for format cells is CTRL + 1. Mac is Command + 1

The formula to fix zip codes that drop the leading zero is =Text(Cell reference, "00000)

To show a blank instead of a zero value:

  1. File
  2. Options
  3. Advanced
  4. Under Display Options turn on or off Show a zero in cells that have zero value
  5. Click OK

Download