Add a Leading Zero in Excel

Add a Leading Zero in Excel

Adding a Leading Zero in Excel

Excel is used to modify documents so they can be imported into Stockbook.
Excel may delete the leading 0 on IDs but they must remain present.

 e.g. the ID number 091234 will appear as 91234 when imported into Excel


Step 1. Highlight the Column

Highlight  the  column  that you wish to alter by clicking on the  letter  above it

 

Step 2. Format Cells

Then right click on that column and go down to  Format Cells

 

Step 3. Customise Numbering

Click on the N umber  tab and then  Custom  category and change the type to 00000# (This is for a number that has 6 digits).

Then click the  OK  button

The numbers should now appear as 091234 rather than 91234


Article ID 908

    • Related Articles

    • Adding a leading zero to a number in excel

      Adding a Leading Zero in Excel Excel is used to modify documents so they can be imported into Stockbook. Excel may delete the leading 0 on IDs but they must remain present e.g. the ID number 091234 will appear as 91234 when imported into Excel Step ...

    • How to Save an Excel File as a CSV File

      Always create a copy of a .csv file before opening to avoid loss of data If you are importing data from excel into Stockbook the file must be in a Comma Delimited file otherwise known as a .csv file. If you have long numbers in your file (e.g. Sheep ...

    • Duplicate values in Excel

      Finding and highlighting duplicates in an Excel spreadsheet column: An example of when you may wish to find duplicates in Excel is to confirm that there has not been any human error when inputting data into Excel. Step 1. Highlight the column in ...

    • Add Animal

      To add an animal in Stockbook ensure you are on your animal screen then select Add on the bottom left hand side of the screen. You will then be prompted to add in the animal details. After adding the required details, select OK at the bottom of the ...

    • Exporting contact list to excel

      Step 1. Contacts Click on the Contacts toolbar icon. The list presents basic details of every contact in your database. A Dark Green background means that you have selected the contact. You may select contacts in a continuous group by clicking on the ...