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)