Dividing dollars by a decimal in Excel

What is the error? The formula you have is fine if both cells contain number values. Can you post your workbook?

I tried copying and pasting it as plain text and it worked.  I'm thinking that it's carrying over some formatting from the Chase.com page I'm pasting it from.  Is there a way to remove or see any special formatting in a single cell or column?

First dollar formatting may change the decimal place so take care on that. Second why not use =(C3/E3)   Not spaces. That could be the formatting issue.

I think I did try rewriting it as such but it still have me a value error.

Make sure the dollar amount and square foot amount are numbers, not text or other format. Change to Number with the format icon.

Removing the spaces from the formula won't do anything. Spaces are ignored within formula.

To remove additional spaces or non-printing characters, use the CLEAN function...

=CLEAN(C3)/CLEAN(E3)

BTW, if the values are stored as Text but otherwise look like real numbers, Excel is smart enough to convert them to numbers by using simple maths operations, such as dividing.

If the CLEAN function doesn't work, there is likely to be a nonbreaking space character that is often used in HTML. You'll need to remove this manually, or use the substitute function (substituting CHAR(160) for "").

Try

=(C3 / iif(E3=0, 1, E3))

Select allOpen in new window

My old job had a strange system that would break older versions of excel formula logic. Our internal workaround was to multiply the data by 1 to convert text to numeric. Try this:

=SUM(C3*1/E3*1)

Take a look at the following web page, and type in any address:

https://www.chase.com/mortgage/mortgage-resources/home-value-estimator

It will give you the comps in the area below the map.  Copy and paste the rows of comps into Excel and you'll see what I mean...there's something about the formatting that's being carried over that Excel doesn't like you performing math on.  However, if you "paste special" as text then it works fine.

I tried the "clean" function and it didn't work.

Thank you.