The problem here is one of mathematics I think. 0.035 is in fact 3.5% (that is, it’s 3.5 hundredths of 1. Similarly, 69 is 6900 hundredths of one. These systems (excel is the same), are trained to recognize decimals and their equivalent %ages as the same – therefore .5 and 50% are the same thing. If you have a column of numbers that are the % you want to display, make another column dividing the first by 100, then make that column into %ages. 69/100 = .69 = 69%.