The content of the cell with the numerator is text.
Formatting the cell as numeric after the fact does not
change the content - it's still a text string.

Click on the numerator cell and do this:

1. Press <Ctrl<Shift<~.
2. Press F2.
3. Press <Enter.

The string in the numerator cell should now be a number.

HTH
Jason
Atlanta, GA

-----Original Message-----
I keep getting a #VALUE error when trying to divide two
cells. They are
both numbers with decimals. In the error, I click
to "show calculation
steps" and see this:

"850.00 "/29634

How can 850.00 be a string if the cell format type is
numeric with two
decimal places?

How can I put the 850.00 as numeric and perform the
calculation?

Thanks,
Brett


.