Text to Columns

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

While attempting to convert text to columns one of the columns is dropping a
digit and adding a 0 to the number.

2008135701620201 after deliminating and sorting to columns this number
appears as 2008135701620200 even though it appears correct in the import text
wizard.
 
I think you've reached the limit of the number of digits of precision that
excel can handle - the same thing happens on my system.
 
Excel does not support more than 15 digits in numbers.

you should format as text during the text to column process

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"JP" escreveu:
 
Back
Top