Excel currency

[Bob B]

I have columns of number and need to change that column
to CURRANCY. How can I do that without adding a decimal
at the end followed by 2 zeros.
Bob B

 

[Don Guillett]

just select the cells/column>right click>format
cells>number>currency>options.

 

[Gord Dibben]

Bob

Sub Currency_Format()
With Selection
.NumberFormat = "$#,##0"
End With
End Sub

Gord Dibben Excel MVP