% fields not displaying correctly

Shawn Brandwein

Why do my % fields sometime automaticly round up (4.6% displays as 5%) and sometimes they display correctly (4.6% as 4.6%). 

 

When I average those fields out it is wrong when i have the fields as %.

 

Here is what I enter into the fields with the % turned off

Mar 30   Apr 3     April 6          Monthly Average

0.048     0.040    .050             .046

 

Here is what is displayed when I have the % field turned on

Mar 30   Apr 3     April 6          Monthly Average

5%          4%         5%                5%

 

Obviously there is a big difference in what is being displayed.

 

monthly Average Formula:

=AVG(April20, [Column3]20, [Column4]20, [Column5]20)) 

Kazarenko

Hi,

 

This looks like a rounding issue. Try formatting the cells that are % by highlighting tham and using the Increase Decimal button (this should be under the % button and looks like 3 zeros and an arrow). Each time you hit the button it will give one extra decimal place in the percentage.