If your desire is simply to interpret "3 1/2" and return 3.5 (for example), then you don't have to write a VBA program to do it. You can, if you want, and we'll help you; but you can do it using worksheet functions. See Sheet2 on the attached for one way to do that.
If you still want to do it with a program—and that might be simpler, from the point of view of the person using the workbook—feel free to say so, and I'll show you how to do that instead.
|