Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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. "JP" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
Linking text columns with text and data columns | Excel Worksheet Functions |