VALUE err calculating indirect number
shg - yes, =VALUE(INDIRECT(A10)) also gives the VALUE! error.
David - I think you are onto the problem, but how do I get rid of
non-breaking spaces formulaicly. I tried reading the web copy directly with:
=VALUE(TRIM(Sheet1!A61)) and it still gives me the VALUE! error.
|