That isn't working. Also, I'd like to apply the conversion to a column.
Any other suggestions?
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
.
|