Excel Rounding Issue

[Jennpen1]

I have a number that has 8 decimal places (0.12345678). When I use the toolbar "decrease decimal" button to hide decimals places it works fine. But then when I use the "increase decimal" button it rounds the number and shows zeros. i.e 0.12345678 --> decrease twice to 0.123457 --> increase twice to 0.12345700

Any idea as to why this is happening? Is there some setting that needs reset?

 

[KenWright]

Tools / options / Calculation / Uncheck 'Precision as displayed'

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[Jennpen1]

That worked.

Thanks Ken!

 

[KenWright]

You're welcome

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------