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

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