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.
How do I format the number to be standard formatting (with comma's), currency, etc?
TIA,
John S.