Using text and formatting sum function in formula
 

I am attempting to show text in a cell concatenated with the sum function and
it works fine. The problem is the result has 10 decimal places in the
resulting number. I have tried to use the format function with the sum
function without success. Here is the formula I am working with:

="Total is: " & Format(SUM(B96:B104),"0.00")

What am I doing wrong?
Thank you.

Using text and formatting sum function in formula
 

Try it like this...

="Total is: "&ROUND(SUM(B96:B104),2)

--
Biff
Microsoft Excel MVP


"Billy B" wrote in message
...
I am attempting to show text in a cell concatenated with the sum function
and
it works fine. The problem is the result has 10 decimal places in the
resulting number. I have tried to use the format function with the sum
function without success. Here is the formula I am working with:

="Total is: " & Format(SUM(B96:B104),"0.00")

What am I doing wrong?
Thank you.

Using text and formatting sum function in formula
 

Hi Billy,

Try using the ROUND function.

="Total is: "&ROUND(SUM(B2:B3),2)

Omit the spaces around the &.

Squeaky

"Billy B" wrote:

I am attempting to show text in a cell concatenated with the sum function and
it works fine. The problem is the result has 10 decimal places in the
resulting number. I have tried to use the format function with the sum
function without success. Here is the formula I am working with:

="Total is: " & Format(SUM(B96:B104),"0.00")

What am I doing wrong?
Thank you.

Using text and formatting sum function in formula
 

The function is TEXT, not FORMAT
--
David Biddulph


"Billy B" wrote in message
...
I am attempting to show text in a cell concatenated with the sum function
and
it works fine. The problem is the result has 10 decimal places in the
resulting number. I have tried to use the format function with the sum
function without success. Here is the formula I am working with:

="Total is: " & Format(SUM(B96:B104),"0.00")

What am I doing wrong?
Thank you.