How to avoid rounding and display only 2 decimals
Summary
How to avoid rounding and display only 2 decimalsContent
There is a delivered column on worksheet that is configured to show 2 decimals and no rounding. value on worksheet is 24.04.
I change decimals to 3 and still no rounding. Value is now 24.039.
However, I want to display only first two decimals and NOT apply any rounding. I did try several options of rounding down to .01, .1, .001, etc with 2 decimals but no success. It always displays value as 24.04.
How can I achieve this requirement to display value as 24.03 only?
I am not able to upload pictures here for some reason. Please refer the attached document.