You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to avoid rounding and display only 2 decimals

edited Sep 5, 2020 12:17AM in Compensation 4 comments

Summary

How to avoid rounding and display only 2 decimals

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!