Using Eval(Replace([fruit],X,*)
10 X 10 = 100
But how to make this
When i type 10 X 10 automatically ==> 10mm X 10mm
produce 100 without error
In short, i want to make the word "mm" look existence but inexistence in
calculation
Any solution?
Thanks in advance
Kennykee
jl5000 - 05 May 2005 22:37 GMT
replace([MyFormula],"mm","")
if you have other characters you need to account for all those combinations,

Signature
jl5000
<a href="http://joshdev.com"></a>
> Using Eval(Replace([fruit],X,*)
> 10 X 10 = 100
[quoted text clipped - 11 lines]
>
> Kennykee