Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

3 Answers 3

I don't think chuff's suggestion will work, since the B2 value is appended to the number, not added. This is probably what you need:

="Total Invoice: "&text(B1+B2,"$#,##0.00")
share|improve this answer

DOLLAR function will display your default currency, e.g.

="Total Invoice: "&DOLLAR(B1+B2)

share|improve this answer
    
This worked perfectly, thanks! –  Jordan Jan 30 '13 at 16:05

This formula will give the proper formatting:

    ="Total Invoice: "&TEXT(B1,"$#,##0.00")&B2

Note that the dollar sign is taken care of in the format specified in the TEXT function, so no need to include it in the initial string.

You can find more information about the TEXT function here.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.