Printing floating point numbers

  • Thread starter Thread starter reuben.nantogmah
  • Start date Start date
R

reuben.nantogmah

Hi,

Here is a problem I am like help with regard to rounding in excel.

4.4 is rounded to 4. So 4.4 + 4.4 = 8.8 which is correctly rounded to
9. When this is printed, the user sees 4 + 4 = 9. Clearly, this has the
tendency to confuse. I would like to avoid rounding when printing and I
would appreciate any advice or tips.

Thanks,

-R
 
But which one shouldn't "round"? The 4s or the 8? Be aware that hey are not
really rounded, they are only displayed inaccurately.
Really the only way to get this right is to display enough decimal
positions.
See also

http://www.mcgimpsey.com/excel/pennyoff.html

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Hi,

Here is a problem I am like help with regard to rounding in excel.

4.4 is rounded to 4. So 4.4 + 4.4 = 8.8 which is correctly rounded to
9. When this is printed, the user sees 4 + 4 = 9. Clearly, this has the
tendency to confuse. I would like to avoid rounding when printing and I
would appreciate any advice or tips.

Thanks,

-R
Click to expand...

Well, if you format the numbers as "General" then they should print
non-rounded.

Is it that you want to display the rounded values on the worksheet, but print
them non-rounded?

If so, you could use a VBA event routine (Workbook_BeforePrint) to temporarily
change the formatting, and then change it back after the printing is finished.
--ron
 
Thanks for all your very helful responses. I think the
Workbook_BeforePrint event is probably the best method to solving this
problem. All I need to do is to change the number formatting
temporarily just before print and reset after the print event is
complete. Thanks again.

-Reuben
 
Thanks for all your very helful responses. I think the
Workbook_BeforePrint event is probably the best method to solving this
problem. All I need to do is to change the number formatting
temporarily just before print and reset after the print event is
complete. Thanks again.

-Reuben
Click to expand...

You're welcome.


--ron
 
Back
Top