ROUND formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bob4@scc.net - 28 Aug 2005 07:07 GMT

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?

Reply to this Message

Barry Wainwright - 28 Aug 2005 11:12 GMT

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.

Signature

Barry Wainwright
Microsoft MVP (see http://mvp.support.microsoft.com for details)
Seen the All-New Entourage Help Pages? - Check them out:
<http://www.entourage.mvps.org/>

> From: <bob4@scc.net>
> Organization: http://groups.google.com
[quoted text clipped - 4 lines]
> 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?

Reply to this Message

Mac Forum / Applications / Excel / August 2005

ROUND formula