There is no excuse for this other than it's a weekend and I'm bored<g, but
here is an alternative formula to do the same thing...

=INT(--SUBSTITUTE(A17,"/","."))

Rick


"Bob Phillips" wrote in message
...
=--(LEFT(A1,FIND("/",A1)-1))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Aden" wrote in message
...
I have a web query which gives me the result "385/1700" and all I want is
the
first part "385" to allow me to do calculations with, but because it's a
web
query, it wont let me just format it as a fraction and times it by 1700..
it
comes up with the #VALUE! error.

So I dont know what else to try,
Can anyone help?

Thanks,
Aden