% on numbers - (easy question probably)

  • Thread starter instereo911 via OfficeKB.com
  • Start date
I

instereo911 via OfficeKB.com

Good afternoon,

This is probably an easy question, but I have a pretty big sheet with numbers
that were imported (i.e. 22.61). I want all these numbers to be converted to
a % but i need the percentage to be after the number (i.e 22.61%). When I use
the format cells and put percentage it brings the number to 2261.00%.

Is there any way around this.

Thank you again
 
I

instereo911 via OfficeKB.com

instereo911 said:
Good afternoon,

This is probably an easy question, but I have a pretty big sheet with numbers
that were imported (i.e. 22.61). I want all these numbers to be converted to
a % but i need the percentage to be after the number (i.e 22.61%). When I use
the format cells and put percentage it brings the number to 2261.00%.
Click to expand...

I don't want to have to press F2 and a % after each number (because there are
tons of numbers) ..
 
B

bj

in an empty cell enter 0.01 and copy
select all the numbers you want to convert and paste special multiply
format-cells-number-percent and select 2 decimal places.
 
Top