how do I convert copied Text numbers into values in Excel?

did you try this
select empty cell. edit-copy goto the cell containing number-text
edit-pastespeical
in pastespecial window under operation click <add> and ok it.


MOE <MOE@discussions.microsoft.com> wrote in message
news:3FB02C9F-4038-4D06-AD80-D1CE8023659C@microsoft.com...
> Copied spreadsheet from third party program to create formulas. However,
> numbers were inserted as TEXT "144,116,991.10" but the quotes only show
when
> reviewing values in the formuls error. Need to know how to covert this
text
> into a number.

did you try this
select empty cell. edit-copy goto the cell containing number-text
edit-pastespeical
in pastespecial window under operation click <add> and ok it.


MOE <MOE@discussions.microsoft.com> wrote in message
news:3FB02C9F-4038-4D06-AD80-D1CE8023659C@microsoft.com...
> Copied spreadsheet from third party program to create formulas. However,
> numbers were inserted as TEXT "144,116,991.10" but the quotes only show
when
> reviewing values in the formuls error. Need to know how to covert this
text
> into a number.

Copied spreadsheet from third party program to create formulas. However,
numbers were inserted as TEXT "144,116,991.10" but the quotes only show when
reviewing values in the formuls error. Need to know how to covert this text
into a number.

did you try this
select empty cell. edit-copy goto the cell containing number-text
edit-pastespeical
in pastespecial window under operation click <add> and ok it.


MOE <MOE@discussions.microsoft.com> wrote in message
news:3FB02C9F-4038-4D06-AD80-D1CE8023659C@microsoft.com...
> Copied spreadsheet from third party program to create formulas. However,
> numbers were inserted as TEXT "144,116,991.10" but the quotes only show
when
> reviewing values in the formuls error. Need to know how to covert this
text
> into a number.