round down to 2 decimal places as a general rule

hello

i need to set quite a lot of excel documents to round down numbers to 2 decimal places instead of default natural rounding. for example, i need number 10.1268 to display as 10.12 instead of 10.13. i need this as a general rule because otherwise i would have to put rounddown() into every single cell in dozens of documents and it would also spoil the calculations.

is there a way to make this?

thanks!

jp

hey, pike
that's not it. i need to avoid rounding. what you suggest makes 4.57 out of 4.56789. i need the result to look like 4.56 even though the real number is 4.56789

Originally Posted by pike

Hi janaper

Would
Tools> Options > edit> Fix decimal places to Two .... be a viable solution for you?

nope, three decimal places is not the way.
well, i was afraid the only way is rounddown

nevermind! thanks anyway