Text to Columns

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

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

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Need to create a text number from other columns 2
working with columns with custome formatting ? 2
Need to create a number from other columns 3
Importing Long Numbers as Text cells 1
Importing Large Text Files 1
converting commodity prices 2
Getting Text data using the Data - Subtotal feature 1

Top