Put in cell N7 the formula below. The mod function with one will only show
th efractional part of the stock.

=mod($L7,1)

Then copy to all cells you want the fraction part to show.




"atin" wrote:

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.