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?

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?

A tiny trick is required. if a cell is formatted as percent and you click on
it and touch 1 ENTER, Excel will put 1% in the cell. If however, you touch
..1 ENTER, Excel puts 10% in the cell!!

If you really want .1% in the cell, you must enter:
0.1
and not
..1


This is one of the few cases in which typing a leading zero will affect the
value in the cell.
--
Gary''s Student - gsnu200778


"Rasput1m" wrote:

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?

so again does this mean there are two ways to achieve 0.1%
1. enter = .01
2. enter = 0.1

this is getting to be more of a nightmare.... than i thought
i thought i liked excel..... for its absolute simplicity and consistency

"Gary''s Student" wrote:

A tiny trick is required. if a cell is formatted as percent and you click on
it and touch 1 ENTER, Excel will put 1% in the cell. If however, you touch
.1 ENTER, Excel puts 10% in the cell!!

If you really want .1% in the cell, you must enter:
0.1
and not
.1


This is one of the few cases in which typing a leading zero will affect the
value in the cell.
--
Gary''s Student - gsnu200778


"Rasput1m" wrote:

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?

There are three ways to acheive .1%

..1%
0.1
..001

..01 sadly gets you 1%


--
Gary''s Student - gsnu200778


"Rasput1m" wrote:

so again does this mean there are two ways to achieve 0.1%
1. enter = .01
2. enter = 0.1

this is getting to be more of a nightmare.... than i thought
i thought i liked excel..... for its absolute simplicity and consistency

"Gary''s Student" wrote:

A tiny trick is required. if a cell is formatted as percent and you click on
it and touch 1 ENTER, Excel will put 1% in the cell. If however, you touch
.1 ENTER, Excel puts 10% in the cell!!

If you really want .1% in the cell, you must enter:
0.1
and not
.1


This is one of the few cases in which typing a leading zero will affect the
value in the cell.
--
Gary''s Student - gsnu200778


"Rasput1m" wrote:

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?

gary's student
quite right! of course = schoolboy error..;-(

thats why i'm not a programmer i guess.....

three ways = that ol' %sign !!!!!! to do everything!!!!! should have
known...... its the same in autocad - my <profession

tks again

"Gary''s Student" wrote:

There are three ways to acheive .1%

.1%
0.1
.001

.01 sadly gets you 1%


--
Gary''s Student - gsnu200778


"Rasput1m" wrote:

so again does this mean there are two ways to achieve 0.1%
1. enter = .01
2. enter = 0.1

this is getting to be more of a nightmare.... than i thought
i thought i liked excel..... for its absolute simplicity and consistency

"Gary''s Student" wrote:

A tiny trick is required. if a cell is formatted as percent and you click on
it and touch 1 ENTER, Excel will put 1% in the cell. If however, you touch
.1 ENTER, Excel puts 10% in the cell!!

If you really want .1% in the cell, you must enter:
0.1
and not
.1


This is one of the few cases in which typing a leading zero will affect the
value in the cell.
--
Gary''s Student - gsnu200778


"Rasput1m" wrote:

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?