Numeric cell but shows as string?
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
|