Green triangles

S

Stevethedoc

thanks for such a speedy response, teh placement of 1 in cell an
edit,paste special, multiply works, but why?

the value function doesn't work, as the green triangle seems to rende
the contents of the cell as neither number or text. strange.

once again thanks :
 
T

tjtjjtjt

Happy to help.
Thanks for the feedback.
As to why one works and not the other, maybe Microsoft knows. The Help File
for VALUE might shed some light--it states the formula is provided for
compatibility with other spreadhseet programs only.

tj
 
Top