How to change the format of EID’s and SG’s ID in excel

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. Excel may show the ID number in the format of "9.82+14" and this can be resolved by following these steps:

Step 1. Prevent Loss of Original Data

To prevent the loss of data, always make a copy of this type of file before opening in Excel.

Step 2. Select Column to Format

Click on the letter at the top of the column to format the whole column

Step 3. Format the Cells

To change this right click on the column and go down to Format Cells.


Step 4. Change the Column Category

Under the Number tab change the category of the column to Number with no decimal places and Click OK.


Step 5. Column Reformatted

The numbers will then be displayed in the format shown below and can be imported into Stockbook



Article ID 906



    • Related Articles

    • Flock ID

      Flocks are setup so that the Sheep Genetics (SG) 16 digit identifier can be calculated correctly. Australian sheep identification system provides a unique sheep identification (ID) for sheep in any breed, across all flocks, anywhere in the world. The ...

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

    • Bulk Change - Joining Dates

      Bulk Change - Joining Dates Select a group of animals and change the joining dates for the entire group, rather than having to do each animal individually. Please ensure you do a backup before doing any bulk changes. A bulk change cannot be 'Undone'. ...

    • Bulk Change - Assign Practitioners

      Bulk Change - Assign Practitioners When using Stockbook, sometimes the need arises to change a certain piece of information over an entire group of animals. To do this you should use the 'Bulk Changes' feature. This allows you to select a group of ...

    • Setting the SG Management / Genetic Management Group

      Setting the Sheep Genetics (SG) Management Group (Sheep) or Genetic Management Group (Cattle) for animals can be done individually, or in bulk. The SG Management Group/Genetic Management Group is used to differentiate animals when performance ...