Hi
you're probably entering 10?
1% is equal to 0.01
so you may enter 0.10 in your example or enter 10%
either should work

--
Regards
Frank Kabel
Frankfurt, Germany

"f16pilot" schrieb im Newsbeitrag
...
When I use a function or formula to fill a cell formatted as
percentage,
Excel ignores the whole number rule and always multiplies by 100, so
instead
of 10% I get 1000%. Is there a way to correct this?