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 for Stockbook. e.g. the ID number 091234 will appear as 91234 when imported ...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 ...Add Animal
To add an animal in Stockbook 1. Select Add Enter the animal details Select OK to add the animal into Stockbook. Article ID 4186Duplicate 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 ...Importing tag bucket files to add to existing animals
Tag Bucket Files are used to import e.g. NLIS IDs for cattle that are already on Stockbook. When you purchase your NLIS tags request the supplier provides a file (either on disk or email) containing NLIS IDs and related EIDs. This list can also be ...