On 24/10/2014 21:58, Richard S. Russell wrote:
>
>> On 2014 Oct 24, at 14:47, Eric Van Deputte <[log in to unmask] 
>> <mailto:[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
>
>
> Do you need them to be STORED that way or only DISPLAYED that way? 
> Because displaying is easy. You can do it under the “Data Formatting” 
> section of the “Data” tab under the inspector:
>
>
To be stored  to be exported ...

-- 

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