Q.  Ever wondered how to enter numerical data, that starts with zero, in to an Excel spreadsheet?

A. In Excel, cells take on the format 1, 2 etc instead of 001 or 002.  To change this, or similar, use the following steps -

  • Click on the cell or cells
  • Right click and choose Format Cells
  • In the Category tab click Custom
  • Click in the 'Type' box, delete what is there and enter 000 (or as many zeros, as you want depending on how many digits are in your data)
Delicious Digg Facebook Fark MySpace