Data formatting in the “Inspector” can give a field that appearance. To have the value actually rounded to two decimal places something like: (int(X * 100))/100
On Oct 24, 2014, at 3:47 PM, Eric Van Deputte <[email protected]> wrote: > Hi everyone, > > I'm in the urgent need of a formula that gives me always a numberfieldresult > with no more and no less than 2 decimals ( "xxxxx.00" ) .... > The data from which the result has to be to calculate can be something like: > 0.01 > 0.10 > 0.1 > .01 > 16.01 > 11 > 111.00 > > an are first rounded to 2 decimals > > -- > > mvg > -------- > > Dr. Eric Van Deputte dvm > 1750 Lennik > [email protected] > www.vwin.be > phone +32(0)2 523 32 95 > gsm: +32(0)475 34 80 36 > fax +32(0)70429537 > > > --- > Dit e-mailbericht bevat geen virussen en malware omdat avast! > Antivirus-bescherming actief is. > http://www.avast.com
