Thread: How do I get the total to show up in dollars?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
fitful_thought fitful_thought is offline
external usenet poster
  
Posts: 20
Default 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


Reply With QuoteReply With Quote