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