Adding a leading zero to a number in excel

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 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

    • 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 ...
    • Adding an EBV type

      Adding an EBV type Adding an EBV type and import relevant data To add an index: Click on the Setup > Performance > Trait Analysis System menu option Scroll through the list of EBV's until you come to BObject Select one that does not have a tick in ...
    • 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 ...
    • Import Sheep Genetics data into Stockbook

      Import Sheep Genetics Data into Stockbook Go the Sheep Genetics website: http://www.sheepgenetics.org.au/Home Login to the Sheep Genetics system using your login and password Find the file to import and save it to a convenient location Open Stockbook ...
    • How to change the format of EID’s and SG’s ID in excel

      Changing the Format of EID's and SG's in Excel Excel may show long numbers such as Electronic Identifications and Sheep Genetics' Identifications in the wrong format. This can be modified in excel so that they are in the appropriate format. e.g. ...