PERCENTAGE FORMAT NOT WORKING

  • Thread starter Thread starter Rasput1m
  • Start date Start date
R

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?
 
That's the way Excel works. The developers thought they were being helpful.

Regards,
Fred
 
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.
 
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!
 
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
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
 
Back
Top