That's the way Excel works. The developers thought they were being helpful.

Regards,
Fred

"Rasput1m" wrote in message
...
when i put in a number less than 1 it does the <<right thing =
multiplies
the number by 100 and adds a % on the end

when the number i add is 1 or bigger - it just adds a % - which means to
get
100% is <<unusual input

am i doing something wrong?

so fred does that mean there are <<two ways to achieve 10%
1. enter = 0.1
2. enter = 10

and the only way to achieve 100% is to enter = 100?

is that supposed to be helpful? in whose books?

tks anyway!

"Fred Smith" wrote:

That's the way Excel works. The developers thought they were being helpful.

Regards,
Fred

"Rasput1m" wrote in message
...
when i put in a number less than 1 it does the <<right thing =
multiplies
the number by 100 and adds a % on the end

when the number i add is 1 or bigger - it just adds a % - which means to
get
100% is <<unusual input

am i doing something wrong?