Excel currency

  • Thread starter Thread starter Bob B
  • Start date Start date
B

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
 
just select the cells/column>right click>format
cells>number>currency>options.
 
Bob

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

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set automatic currancy decimal without entering the decimal? 3
VBA - Run same logic on values in columns 2 & 3 0
Auto number formatting 19
How can I set up an excel file to auto import data from a CSV fil 1
Merging excel info into a word table 2
data entry validation 1
Str to Currency round problem 4
Formula that checks balances 3

Back
Top