Hello,
I have a form where I there is a calculated field which I want to have available as a column in WSS 3.0. The field is set as a Decimal type, and formatted for 2 decimal places (it's a currency 29.99). The problem is when the value appears in the Sharepoint column it appears with 3 decimal places. So instead of the CORRECT currency value of 94.98 the value is 94.975.
The column type in WSS is Number but I can't click on it to change it.
How can I fix this? THANKS!