View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
atin atin is offline
external usenet poster
 
Posts: 7
Default 0.1 to 0.99 not recognised or calculated when results from formula

Problem- Problem- Excel not recognising or counting values between '0.01 to
0.99' in
cells containing formula. Exact sheet can be downloaded at-
http://www.aensia.com/test.zip

In the sheet you download - I want to know which stock is equal to 0.1, 0.2,
0.3 and so on.

Excel is not giving right values in (stock equal to 0.1, 0.2 and others).

Is there any solution to this.