Excel currency
 

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

Excel currency
 

just select the cells/columnright clickformat
cellsnumbercurrencyoptions.

--
Don Guillett
SalesAid Software

"Bob B" wrote in message
...
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

Excel currency
 

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