Bob

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

Gord Dibben Excel MVP

On Fri, 9 Jan 2004 07:07:53 -0800, "Bob B" wrote:

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