close

PS Stockbook

Excel is cutting off numbers from Id.

Summary

Excel is cutting off numbers from the animal Id. when I export

Detailed Description

Open a new excel file

Step 1. 

Data tab > From Text > select file that has data in it.

Step 2.

Choose 'Delimited' as Original data type then click on Next.

Step 3.

Under Delimiters check 'Comma' & uncheck 'Tab', then click on Next.

Step 4.

Select all of the columns (use the shift key to highlight multiple columns), then click on the Text radio button. Click the Finish and then OK.

 

Was this helpful?

Not helpful ( ) Very helpful