Thread: How do I display results of a summation in the following format?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default How do I display results of a summation in the following forma
To handle just decimals ie; to display .563 as 0.56 and not as .56 try the
below

="Total = "& TEXT(SUM(A1:A12),"#,##0.00")

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Try the below.

="Total = "& TEXT(SUM(A1:A12),"#,##.00")

If this post helps click Yes
---------------
Jacob Skaria


"Nh2" wrote:

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