Dollar amount in middle of sentence.

[hviking]

Quick question for everyone:

Cell a1 contains $ 4,322.50, formated as currency. So far so good.

Cell b1 contains:
=''Your total will be ''&a1&'' plus tax''

It shows up as:
Your total will be 4322.5 plus tax

How can I make it show up format as currency?
I.e. : Your total will be $ 4,322.50 plus tax

Any suggestions??

Thanks as always.

 

[babycody]

="Your total will be "&DOLLAR(A1,2)& " plus tax"

 

[Krishnakumar]

Try,

="Your total will be "&TEXT(A1,"$ #,##0.00")&" plus tax"

HTH

 

[hviking]

Told you it was simple

Yep, I should have known that one. Haven't had to use DOLLAR in a while.

Thanks again folks;

 

[Peter_SSs]

No better than the others, but slightly different:
="Your total will be $"&FIXED(A1,2)&" plus tax"