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

"assaf1978" wrote:

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?