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 ...Quick Add Tally
This feature will allow you to see a tally of the fields that have been used in the Quick Add. For Example: If you are inducting new animals and want to see a tally of males and females Step 1. In Live Entry go to View > Data Windows > Tally Step 2. ...