# PERCENTAGE FORMAT NOT WORKING

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?

F

#### Fred Smith

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

Regards,
Fred

G

#### 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.

R

#### 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!

R

#### 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

G

#### Gary''s Student

There are three ways to acheive .1%

..1%
0.1
..001

R

#### 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