Excel is cutting off numbers from Id.

Excel is cutting off numbers from Id.

Excel is Cutting off Numbers from ID

After Exporting data, Excel is cutting off Numbers from ID's.

Step 1. Open a New Excel File

  1. Select Data tab
  2. Select From Text
  3. Select the file that has data in it


Step 2. Choose File Type

  1. Choose 'Delimited' as Original Data Type
  2. Click on Next


Step 3. Confirm Delimiter Choices

Under Delimiters: 

  1. Check 'Comma'  
  2. Uncheck 'Tab'
  3. Click on Next


Step 4. Column Data Format

  1. Select all of the columns (use the shift key to highlight multiple columns),
  2. Click on Text under Column Data Format
  3. Click Finish and then OK


Your file should now print correctly.


Article ID 418

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

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

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