Multiply?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
replace([MyFormula],"mm","")

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