I dont know a whole lot about empirical and metric conversion but I do know that VBA can do what you are looking for. Are you using a particular formula to convert them? VBA has the ability to check a string for the amount characters easily. It can also evaluate each character in the string the possibilities are close to unlimited. If you can tell me the formula you use or what exact conditions you need this can be written.
Thanks