Because changing the display doesn't change the value XL uses to
calculate follow-on calculations (unless the Precision as displayed
option is set).

And of course there's a practical limit ot using INCREASE DECIMAL: XL
only carries 15 decimal digits of precision, so for a number =1, if you
have 10,000 decimal places, the last 9,986 will all be zeros.

In article ,
Danny C wrote:

Why not use INCREASE DECIMAL. It works in my spread sheet? You can increase
the decimal number to what you want - there's no practical limit. (10-10,000
decimal places.)