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? |
#2
|
|||
|
|||
After you paste those "text numbers", you can convert them.
Copy an empty cell select your range of offending numbers/text edit|paste special|check Add peter wrote: 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? -- Dave Peterson |
#3
|
|||
|
|||
I'm still confused. Could you explain it another way? Where do I find
"text edit"? Thanks. Peter |
#4
|
|||
|
|||
Copy an empty cell
select your range of offending numbers/text edit|paste special|check Add "Select the range that consists of the numbers that are text" may have been a better way of wording that second line. Edit is on the worksheet menubar. peter wrote: I'm still confused. Could you explain it another way? Where do I find "text edit"? Thanks. Peter -- Dave Peterson |
Reply |
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) |