PERCENTAGE FORMAT NOT WORKING

[Rasput1m]

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?

 

[Fred Smith]

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

Regards,
Fred

 

[Gary''s Student]

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.

 

[Rasput1m]

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!

 

[Rasput1m]

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]

There are three ways to acheive .1%

..1%
0.1
..001

..01 sadly gets you 1%

 

[Rasput1m]

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