>>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.
Barbara,
VAL(1/4) will return a syntax error. VAL('1/4') only returns the numerator, not the result of the of 1 divided by 4.
George
Ubi caritas et amor, deus ibi est