View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
instereo911 via OfficeKB.com instereo911 via OfficeKB.com is offline
external usenet poster
 
Posts: 26
Default % on numbers - (easy question probably)

instereo911 wrote:
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%.


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

Thank you again


--
Message posted via http://www.officekb.com