Hi Brett

there's a space after the 850.00 (D2) which means that it is not recognised
as a number
one way to fix it is to delete the space .... have you got many to do?

Cheers
JulieD

"Brett" wrote in message
...
http://www.cygen.com/temp/stringcell.xls

You can see in E2 that is doesn't calculate. Any suggestions on how to
fix it?

Thanks,
Brett
"Jason Morin" wrote in message
...
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


.