From: Billy B on 16 Apr 2010 10:27 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. From: T. Valko on 16 Apr 2010 10:42 Try it like this... ="Total is: "&ROUND(SUM(B96:B104),2) -- Biff Microsoft Excel MVP "Billy B" wrote in message news:00B24B07-2B51-493E-B199-7BBA2860D044(a)microsoft.com...>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. From: Squeaky on 16 Apr 2010 11:09 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. From: "David Biddulph" groups [at] on 16 Apr 2010 12:53 The function is TEXT, not FORMAT -- David Biddulph "Billy B" wrote in message news:00B24B07-2B51-493E-B199-7BBA2860D044(a)microsoft.com...> 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.  |