How do I get the total to show up in dollars?

  • Thread starter Thread starter fitful_thought
  • Start date Start date
F

fitful_thought

How do I get the total to show up in dollars?

Dim total As Currency
total = Cells(1, 1) + Cells(2, 1)
MsgBox total
 
How do I get the total to show up in dollars?

MsgBox Format(total, "$#,##0.00")
 
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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Have TextBox display a dollar value 6
When found add it to the last and display total in Msgbox 23
Sports Arbitrage Formulas 2
Why does cell format change when assigning a value? 2
To SQL Expert: VBA Function that Calls SQL Query 3
For-Next by a row Counting consecutive Zero in the column 4
Spliting digits up to fit paper form 27

Back
Top