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