How add "%" sign to a list of numbers?
 

How can I add a percentage sign to an entire list of numbers in one
operation?

Thanks. Cheers.

How add "%" sign to a list of numbers?
 

You've got some responses in your next, "duplicate" posting <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

How add "%" sign to a list of numbers?
 

Well if the list of numbers is a continuous range you can do it in 3
operations!
Firstly % is just a format, but the number needs to be 100 times
smaller

so type 100 in one cell, select this cell and then select the range you
want to chance and choose paste special operation divide.

Then format your cell as a perentage

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=545749