software

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: quot;$250,000.quot; Whenever I make the
calculations, I get a quot;VALUE!quot; error. This is because it doesn't understand
quot;$250,000quot; has a value. How can I get it to understand that quot;$250,000quot; has a
value of 250,000?

Highlight the column you want for Sales Price. Right click- Then left click
on quot;Format Cellsquot;- Under number tab click quot;Currencyquot;. Don't type the $ key
just the price.

TC

quot;Ufomonsterquot; wrote:

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

I should clarify that I'm not typing in the fields at all, I'm copying from a
database and pasting into Excel. The dollar signs are in the data that I'm
copying. Removing them one by one would be very time-consuminig.

quot;TCquot; wrote:

gt; Highlight the column you want for Sales Price. Right click- Then left click
gt; on quot;Format Cellsquot;- Under number tab click quot;Currencyquot;. Don't type the $ key
gt; just the price.
gt;
gt; TC
gt;
gt; quot;Ufomonsterquot; wrote:
gt;
gt; gt; I need to paste a column of home sales prices, and a column of home square
gt; gt; footages, and calculate based on those two values. (sales price/square
gt; gt; footage)
gt; gt;
gt; gt; BUT...the pasted list is in this format: quot;$250,000.quot; Whenever I make the
gt; gt; calculations, I get a quot;VALUE!quot; error. This is because it doesn't understand
gt; gt; quot;$250,000quot; has a value. How can I get it to understand that quot;$250,000quot; has a
gt; gt; value of 250,000?

Hey everyone, I figured it out. The database I was copying from had a space
after the sales price. ( quot;$250,000 quot; ) So, I used this formula to remove the
contemptable extra space:

=(MID(A1,1,LEN(A1)-1))

(assuming my data is in A1)

which removes the last (rightmost) character from what I pasted.

Hope it helps you out if you run into this.

quot;Ufomonsterquot; wrote:

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