Excel currency

Bob B · Jan 9, 2004

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 · Jan 9, 2004

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

Gord Dibben · Jan 9, 2004

Bob

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

Gord Dibben Excel MVP