>Well... The data is coming from a text string like
>12' 3 1/4"
>and I have to convert that to a number so in my case
>val("1/4") won't work...
>
What kind of a number are you trying to get from this? The total number of inches? You'd need to parse the string to pull out the number of feet, inches, etc. but using VAL(1/4) still works for the fraction part of it.