| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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") |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Live Currency Conversion US Dollars to Australian Dollars | Excel Discussion (Misc queries) | |||
| multiply hours/minutes times dollars for total dollar amount | Excel Discussion (Misc queries) | |||
| Show Dollars in Millions | Excel Worksheet Functions | |||
| Adding total dollars based on specific data from another column | Excel Discussion (Misc queries) | |||
| converting #dollars into word dollars? | Excel Worksheet Functions | |||
Linear Mode
