percents

[assaf1978]

Hi,
I have a list of numbers that i would like to show as percents.
Lets say I have 40 and I want it to show 40% and not 4000%. How do I do that?

 

[Mike H]

Hi,

1. Put 0.01 in a cell and copy it. Select your numbers and then Edit|Paste
special, select multiply and click OK.

2. Format as %

3. Delete the 0.01.

Mike

 

[Gary''s Student]

There are two ways:

1. Format > Cells... > Number > Custom > General%
This will change the display, but not the value

2. divide the cells by 100 and then:
Format > Cells... > Number > Percentage
This will change both the value and the display.