Highlight the column you want for Sales Price. Right click- Then left click
on "Format Cells"- Under number tab click "Currency". Don't type the $ key
just the price.

TC

"Ufomonster" wrote:

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?