Formatting Number in Concatenated Cell

[JohnS323]

Hi! I am having a problem formatting a number in cell that is the product of concatenation. My specific case is more complicated than this, but for example sake, let's assume the following: I have values in cells a1:a30. I want cell a31 to say "Total Value: 3,000,000". When I type in the forumla =Concatenate("Total Value: ",sum(a1:a30)), I get the following "Total Value: 3000000".

How do I format the number to be standard formatting (with comma's), currency, etc?

TIA,

John S.

 

[macleanb]

use the format text(is one way) so for exaMPLE

= "Todays sales are" & text(a1,"#,#")

 

[JohnS323]

Thanks! That worked perfectly!