Calulate with only to decimals. (1 Viewer)

[Roelant]

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.

 

[Travis]

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.

 

[Roelant]

Thanks