Hello,

I suggest two have two separate areas here.

One for the calculation, another one for representation.

That way you would just need to apply your cell display change again.

Regards,
Bernd

PS: Enabling Precision as displayed I would never suggest. Please see
topic 4 of my
http://www.sulprobil.com/html/excel_don_ts.html