Copying text to numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

peter - 09 Mar 2005 21:33 GMT

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?

Reply to this Message

Dave Peterson - 09 Mar 2005 21:57 GMT

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

> 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?

Signature

Dave Peterson

Reply to this Message

peter - 09 Mar 2005 23:01 GMT

I'm still confused. Could you explain it another way? Where do I find
"text edit"? Thanks.

Peter

Reply to this Message

Dave Peterson - 09 Mar 2005 23:57 GMT

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.

> I'm still confused. Could you explain it another way? Where do I find
> "text edit"? Thanks.
>
> Peter

Signature

Dave Peterson

Reply to this Message