Good catch JE, we all thought just TEXT did it .....it don't ....but
something like 73,0 instead of 73.0 will cause the error.......

Vaya con Dios,
Chuck, CABGx3



"JE McGimpsey" wrote:

I think that even a TEXT number should return a correct value unless it
has non-space characters in it (e.g., a non-breaking space)...

In article ,
CLR wrote:

I expect that you've got a TEXT number in there instead of a real number.