I need to paste a column of home sales prices, and a column of home square
footages, and calculate based on those two values. (sales price/square
footage)
BUT...the pasted list is in this format: "$250,000." Whenever I make the
calculations, I get a "VALUE!" error. This is because it doesn't understand
"$250,000" has a value. How can I get it to understand that "$250,000" has a
value of 250,000?
Bookmarks