Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Percentage format
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
What's your formula and data? I can't reproduce anything like that if indeed
I use the correct formula for percentage Regards, Peo Sjoblom "f16pilot" wrote: 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? |
#4
|
|||
|
|||
<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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Telephone number format | Excel Discussion (Misc queries) | |||
pivot chart format | Charts and Charting in Excel | |||
How do I change Excel format to pdf format? | Excel Discussion (Misc queries) | |||
How do i change numbers in text format to number format? | New Users to Excel | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |