Because a fractional part in a binary type precisely, and visible you 120,32 actually any 120,31111111119.
Though it is strange... Most likely you 120,32 is the result of calculation displayed with 2 digits after a comma, and in practice it 120,31
It not design values. I hands enter 120,32. Thus it turns out 120,31 = 120,31, and here 120,32 = 120,311111111... And 120,34 again = 120,34
And for example 50,32=50,32 here therefore and interesting, from what??
Adding from 10/5/2017 11:20:
To bypass so it is possible.
Copecks = (C2*100; 2)
To bypass yes, truth protection against the fool not always works, in particular 120,321 produces, 3
Plus at me the task stood actually formation of price lists through Mailing in the Word (a template a Word + data source an ex-fur-tree + + the price) and there important copecks in the double-valued type 00 to cling. I.e. 120,01 = 120 + 01
Interest to learn, why 120,31 it is 120,31, and 120,32 it 120,31111 there still
I by the way solved the problem through tonsils certainly, but these are Mailing singularities
=The TEXT (WHOLE (C3); "0") for roubles
=The TEXT ((C3*100-E3*100); "00") for copecks
And all the same in places clings copecks as (,) i.e. value from a comma (for example 74,) but here I already surrendered and at me this comma simply does not get to a press zone