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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I display results of a summation in the following format? (https://www.excelbanter.com/excel-worksheet-functions/248872-how-do-i-display-results-summation-following-format.html)

Nh2

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 ?

Jacob Skaria

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

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 ?

Jacob Skaria

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 ?

All times are GMT +1. The time now is 07:11 PM.