adding dollar signs
 

howdy.

i have a column of numbers in excel and i want to add dollar signs in front
of them all. There are 100 numbers in the column, can i do this without
adding the dollar signs manually?

gracias,

j.

adding dollar signs
 

Select the column and use

Format Cells Number Currency


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514531