Thread: How do I display results of a summation in the following format?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nh2 Nh2 is offline
external usenet poster
  
Posts: 1
Default How do I display results of a summation in the following format?
Formula: ="Total = "&round(sum(a1:a12),2)"
Assuming the result is 123456.78.

Can the final results be displayed in the cell with number format
(accounting) as...
Total = 123,456.78 ?
Reply With QuoteReply With Quote