For an internal order form I’d like to get two things done:
- In the column “unit price” I want the numbers of decimals to be set to 4 digits (e.g. 3.4509), without any Rounding
- In the columns “total price excl. VAT” and “total price incl. VAT” I want the numbers of decimals to be limited to 2 digits (e.g. 3.45) AND these columns need to be ROUNDED UP to those 2 digits. For instance: 3.4509 must become 3.45 but 3.4589 must become 3.46
At this point, I’ve managed to get these things done, but from within the cells.
But to prevent my colleagues from erasing of tampering with the formulas, I’d like to move these instructions to the VBA-section of the worksheet.
When all the coding is in place, I'll finalize the form by blocking cells from being used.
Thanks for any input.
W.
Bookmarks