| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| display results 2 of 2 | Excel Discussion (Misc queries) | |||
| Display next to last results | Excel Worksheet Functions | |||
| Display results of formulas | Excel Worksheet Functions | |||
| Month Format summation | Excel Worksheet Functions | |||
| Summation format | Excel Worksheet Functions | |||
Linear Mode
