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.

Attached Files

x.xls (30.0 KB, 10 views)