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?