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 réponses

Texture issues in enshrouded

[urgent] what does "prise (aux in)" mean?

Saracroche: the effective french app against phone spam

Double letter keyboard issue

Black screen issue ps3 hdmi

Misunderstanding of the ending of another earth

Connect multiple pcs to the livebox

How to get the character µ on the android keyboard.

Asus, backlight issue

Sims 2 ds issues