I am using excel 2010 and I am working with cells that have percentages in them. For example, 0.62, all of the numbers in each cell are shifted to the left. When I try to do =sum to get the total percentage it only displays 0. The only thing that will work is when I click on each individual cell then click out of it causing the percentage to shift to the right. Once I click on each individual cell and they all shift right the auto sum calculates the percentage correctly. My problem is I am working with a massive amount of percentages so I need an option to make all of the cells with percentages autosum without having to click on each individual cell. Can you advise?