ROUND formula

B

bob4

In Excel (Office 2004) version 11.1.1 the ROUND function in a formula
works on the screen but not in print preview or when printed. Any help?
 
B

Barry Wainwright

If you are seeing such an effect that is an effect of the column width, not
the 'round' function, which physically truncates the number, so there are no
more digits to display.

Widen out the column on screen and see what is there. Then check your usage
of the Round() function.
 
Top