Hi

I merely confirmed that this is a problem in Excel. If you want to enter
5%, there is really only one way, and that is to enter it as .05. If you
want .5%, enter it as .005. Stupid, I know.
The button I referred to, you will find under Tools|Options. Select the
Edit tab, and you have the option to automatically enter numbers as %. If
you untick this option, it goes completely haywire. So I only tried to warn
you on the one hand, and to confirm that we do have a problem. The solution
- who knows?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Abuzzmaster" wrote:

I don't understand. Where is the check box you're referring to? And I
couldn't really tell from your response if this was a solution to the
problem, or just another problem that you've faced that's loosely related.
Could you clear that up for me? And if you have any help I would really
appreciate it. Thanks.

"Kassie" wrote:

Hi

Using Windows 2000 and Office XP I have the same situation at times. Plesae
note the at times part.

Since I never work with fractions, this has never bothered me. Strange
enough, if you, with some percentages in your sheet, untick the Allow
automatic % entry option, and you type in 50, you will get 5000%, 5 will show
500%, .5 will show 50%, .05 will show 5% and so on
Do not untick that option, for your own sanity's sake

--
ve_2nd_at. Randburg, Gauteng, South Africa


"Abuzzmaster" wrote:

I have a spreadsheet I work with every day and I use fractional percentages,
between 0-1%. If the field is formatted as Percentage, and I type in ".5", it
reads it as 50%, which it would be if it weren't a percentage. But it is.
It's a half percent. By typing in "50", I also get 50%, which doesn't make
sense. If I type in "5" I get 5%, if I type in ".5", I should get .5%. Is
there a way to make this happen, or is this just a glitch in Excel? Please
help me figure this out. Thanks.