Converting Text to Number

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

Guest

I copy and pasted a bunch of dollar amounts from a text source, and because
all of the data contains the dollar sign and commas, excel interprets it as
text. The problem is that I need to use this data as numbers, ie. be able to
use the SUM and AVERAGE functions. Is there any way for me to reformat this
data so I am able to do this?
 
Try highlighting the column, then Data > TextToColumns > Delimited > and
remove all delimiter checks > Finish

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

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

convert to text problem 2
convert number into text & Only 3
Number/Text combination formula 8
Convert number to text as displayed 3
Changing Text To Numbers ? 1
numbers to text with formatting 1
Convert numbers into text 1
convert text to dollar 5

Back
Top