Converting Text to Number
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?
|