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 <[email protected]> wrote in message
news:[email protected]...
> 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.
Bookmarks