| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying text to numbers
I have a spreadsheet with a column that has been formatted as text.
The column contains all numbers. I wish to copy this column into another sheet that has the column formatted as numbers. When I do so, it does not treat the entries as numbers, even when I paste only the values. Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
| Text not copying as text from Word to Excel 2003 | Excel Discussion (Misc queries) | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
| I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
Threaded Mode
