How do I insert formula in between sentences with a dollar value formatting as the returned result? For example, in A3 I want to write:
="Total Invoice: $"&B1+B2
So the result should appear as "Total Invoice: $6,548.32"
However, when the formula is entered in excel, results come out as "Total Invoice: $6548.32375"
How can I control the result to only display 2 decimal points as well as the comma when required?