View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheila D
 
Posts: n/a
Default Can't do calculations with the data from a web queries

You haven't given much info but maybe you have formatted your numbers as Text
in which case formulaes won't work

"Martin" wrote:

I get to do the queries, the data is there and refresh and all, but I can't
do a simple calculation with the data. What am I doing wrong? cell format?