disable Excel auto rounding Solved

Question

Hi,

my problem is resolved in the subject title: I want to cancel automatic rounding in Excel.

for example, if I have a cell equal to =f5/b4 which gives 0.1816, I want it to display 0.181 and not 0.182. I check the option: "Set precision as displayed" and nothing changes.

Thank you in advance.

--
Luck sometimes helps, work always does.

Raymond PENTIER · Accepted Answer

=ROUNDDOWN(f5/b4,3)  -- Retirement is great! Especially in the Caribbean... :-) Raymond (INSA, AFPA, CF/R)

Vaucluse · Answer

Hello the display of the number of rounded or unrounded decimals does not change the numeric value, which remains that visible in the formula bar the ROUND code, however, modifies it if you want the exact value as you wrote, and to see it displayed: the cell must be formatted as standard the column must be wide enough to display all decimals (the rounded value displayed in standard format comes from the fact that the column width does not allow for full display) best regards  The quality of the response mainly depends on the clarity of the question, thank you!

Disable Excel auto rounding

2 answers

Tiktok limits suggestive content to 18+ users

Self-invoking js function

Unable to open xsl and xslx files

Copy from excel into google sheets

Invisible text boxes or word forms on pdf

Display issue in google

Use your holiday vouchers to pay tolls for free

Xiaomi redmi note 13 pro+ 5g disable ads?

Transfer data to a new pc

Print a page in the right orientation under windows 11