| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to convert Excel imported numbers from text to numbers?
We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are numbers, they act like text. The only way to convert them text to numbers is to edit the cell (press F2) and hit enter. I've tried every other method of copying and pasting (even pasting special), but nothing seems to work. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| roundoff when converting text to numbers | Excel Worksheet Functions | |||
| convert a number in Excel from numeric to text, i.e. "1" to "one" | Excel Worksheet Functions | |||
| excel - numbers as text | New Users to Excel | |||
| Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
| How to Replace numbers and text with numbers only? | Excel Worksheet Functions | |||
Threaded Mode
