Text to Columns

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

 

[dhstein]

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.

 

[Marcelo]

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:

 

[MyVeryOwnSelf]

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.

In Excel 2003, numbers are limited to 15 digits of precision.

In step 3 of the text-to-column wizard, you can specify a "column data
format" of "text" for the column in question. This keeps all the digits.
But then the values are treated as text, not numbers, so you can't do
numeric calculations with them.