Computer and Software Support


Need a leading zero in the number

help file is for Excel 2003. It may or may not work for older versions as well.

In order for the number to show a zero at the beginning of the number you have to set the cell or cells to either text or zip.  To do this do the following

  1. Right click the cell or cells
  2. Click on Format Cells
  3. Click on the Number tab
  4. Either select Text, Zip Code, or Zip Code +4 under Special
  5. Click on OK