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?
 
Ad

Advertisements

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

..01 sadly gets you 1%
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top