Why did my allowance column become 1000% when I meant 10%?
TechnologyI entered 10 in an Excel column for a materials allowance, then applied Percentage formatting. It now displays 1000%. A colleague suggested dividing the whole column by 100, but some entries were already typed with a percent sign.
Microsoft explains that formatting existing numbers as percentages differs from entering percentages into appropriately formatted cells. Excel's percentage guidance
How would you repair a mixed column without changing values that were already right? I want the calculation to use a ten-percent allowance, not merely make every cell look plausible.