<Tools <Options <Edit tab,
And make sure that "EnableAutoPercentEntry" *IS* checked.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"f16pilot" wrote in message
...
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?
|