MrExcel Publishing
Your One Stop for Excel Tips & Solutions

0” (Zero) in cell but “0.125” in Formula Bar

Posted by A.R. on October 17, 2001 10:33 AM

I have a worksheet that shows “0” (zero) in the cells but in the Formula Bar it is showing “0.125”. I did copy and Paste Special and selected “Values” but I still get “”0.125”.
How do I get rid of “0.125” in the Formula Bar.

Posted by Mark W. on October 17, 2001 10:48 AM

You have to change the precision of your stored
value to match is formatting. See the
Tools | Options... | Calculation menu command.
Check "Precision as displayed".