| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
