Thread
:
Converting Text to Number
View Single Post
#
2
CLR
Posts: n/a
Try highlighting the column, then Data TextToColumns Delimited and
remove all delimiter checks Finish
Vaya con Dios,
Chuck, CABGx3
"Andrew Bartholomew" <Andrew
wrote in
message ...
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?
Reply With Quote