View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aden Aden is offline
external usenet poster
 
Posts: 2
Default How do I separate numbers?

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