It's probable the cell you wish to display the % in is already taking the formating from an adjacent cell, try clearing all formats from it using the format eraset then format it before putting in your formula, say percentages showing 2 places after the decimal then input your formuls