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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Outline view - formatting lost 0
Page numbering with Merged Document and IF statements 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Print order of TriFold - Publisher 365 0
Images are pixelated when saving to PDF 0
Table of content - format does not get saved 2
Document won't print 0
Mis-performing MP4 files in Mac PPT 1

Top