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
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 Select Add Enter the animal details Select OK to add the animal into Stockbook. Article ID 4186
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 ...