AFAIK, there is nothing you can do will change the 'actual' value listed
on the formula bar of that cell without using VBA code.

Except to use Paste Special... Add (or subtract, multiply, divide) In
another cell, enter 0.1 and Copy. Go to your cell with 45.9 and Paste
Special...Add and your cell will now show 46 both in the cell and on
the formula bar.

Not pretty, but it does work in this one instance.


Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=383525