View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel
LunaMoon LunaMoon is offline
external usenet poster
 
Posts: 97
Default weird! Excel refuses to compute numbers...

Hi all,

I copied and pasted the HTML table into Excel.

http://finance.google.com/finance?fs...&q=NASDAQ:FMCN

And when I do "=B11/B10" in Excel,

it complains "#Value!"

I have checked that B11 and B10 are numbers, but why haven't they been
treated as numbers?

And I've tried manipulating other numbers in the sheet (or at least
they are numbers but in a text format, I guess), they all fail ...