Remember Me?

#1
October 29th 04, 04:18 PM
 f16pilot Posts: n/a
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
October 29th 04, 04:20 PM
 Frank Kabel Posts: n/a

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

of 10% I get 1000%. Is there a way to correct this?

#3
October 29th 04, 04:23 PM
 Peo Sjoblom Posts: n/a

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
October 29th 04, 09:47 PM
 RagDyer Posts: n/a

<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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MarkT Excel Discussion (Misc queries) 6 January 18th 05 10:39 PM Valeria Charts and Charting in Excel 1 January 14th 05 01:19 PM William Haskovec Excel Discussion (Misc queries) 1 January 13th 05 12:07 AM Greg New Users to Excel 1 December 14th 04 05:22 PM Dana Zulager Excel Discussion (Misc queries) 7 December 7th 04 11:02 PM

All times are GMT +1. The time now is 11:15 AM.