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

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

Dim total As Currency
total = Cells(1, 1) + Cells(2, 1)
MsgBox total



--
Regards,
David

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

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

MsgBox Format(total, "$#,##0.00")

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

Msgbox Format$(Total,"Currency")


On Sun, 8 Aug 2004 09:54:08 +1000, "fitful_thought" wrote:

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?
 

Thank you for your help. Big lapse of memory here.

"mark" wrote in message
...
How do I get the total to show up in dollars?

MsgBox Format(total, "$#,##0.00")

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

Thank you for your help. Big lapse of memory here.


"Myrna Larson" wrote in message
...


Msgbox Format$(Total,"Currency")


On Sun, 8 Aug 2004 09:54:08 +1000, "fitful_thought"
wrote:

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

Dim total As Currency
total = Cells(1, 1) + Cells(2, 1)
MsgBox total