Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a column with the following data:
A RUT 212874790014 Each cell has the word RUT, and the number changes, altough it always has 12 digits. I need to have the word in one cell and the number in another, so I use the text to column option. But when I finish doing this the result is: A B RUT 21,2875E+11 How can I avoid this, so as to keep displaying the whole original number in the cell? Thanks in advance. Regards, Emece.- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data, Text to Columns, has commas in the text, plus as a delimeter | Excel Discussion (Misc queries) | |||
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 | |||
Linking text columns with text and data columns | Excel Worksheet Functions |