Text to Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JP - 21 May 2008 21:03 GMT

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.

Reply to this Message

dhstein - 21 May 2008 21:12 GMT

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.

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

Reply to this Message

Marcelo - 21 May 2008 21:20 GMT

Excel does not support more than 15 digits in numbers.

you should format as text during the text to column process

hth

Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

Reply to this Message

MyVeryOwnSelf - 21 May 2008 21:23 GMT

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

Reply to this Message