Calulate with only to decimals.

Roelant

Registered User.
Local time
Today, 15:23
Joined
Apr 2, 2002
Messages
36
Can i set de decimal from a currency to 2 numbers instead of 4 and also only counting 2 to decimals. Thank you very mutch by helping me.
 
You can Use Format([YourNumber],"0.00") to format numbers to two decimal places.

For calculations I recommend not formatting/Rounding until you have reached your final answer, as Rounding Errors will be higher.
 
Thanks
 

Users who are viewing this thread

Back
Top Bottom