Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert text to column
Hi,
I have 4000 rows of data that start with "01Exxx.00" and tried using the "convert text to column" function to get rid of digits after the period. However, it all turned into "1E+123.. 1E+233". What can I do to make the numbers show "01E123" without the ".00"? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Changing column size w/o losing text | New Users to Excel | |||
how do i convert a row of data into a column in another excel wor. | Excel Worksheet Functions | |||
How do you convert numbers as "text" to values for a long column . | Excel Discussion (Misc queries) | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions |