How do I display results of a summation in the following format?

  • Thread starter Thread starter Nh2
  • Start date Start date
N

Nh2

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 ?
 
Try the below.

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

If this post helps click Yes
 
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
 
Back
Top