Multiply?

[kennykee]

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]

replace([MyFormula],"mm","")

if you have other characters you need to account for all those combinations,