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 <[log in to unmask]> 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
> [log in to unmask]
> 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