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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Text to Number 3
cannot convert text string into value 16
Text to Number format 5
Convert Number to Text for Index/Match 1
Converting Text to Numbers in Excel w/ Additional Spaces 4
Convert number to text as displayed 3
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Excel Change Excel Text colour from Formula Bar 0

Back
Top