By any chance is the 'Precision as Displayed' box checked on the Calculation
tab under Tools | Options?



"hutcheeez" wrote:

I cannot seem to format cells not to have rounding.
I have increased width of columns, increased decimal places.
Neither helps, what can I do?