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

Thanks. Cheers.

If they are in the same column or row, select the column (or row) then
Right-Click
Format
Number
Percentage -- select the number of decimal places you want
OK

Be warned, this method will multiply the values in the cell by 100
first.


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=545750

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

Perhaps you mean ..

Select the col of numbers,
then click Format Cells Percentage (adjust the dp to suit) OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Either way will work, I tend to use the right-click method, rather than
the menu bar


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=545750