adding dollar signs

[Guest]

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.

 

[daddylonglegs]

Select the column and use

Format > Cells> Number > Currency