Dollar amount in middle of sentence.

hviking

Board Regular
Joined
Mar 31, 2002
Messages
59
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.
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

hviking

Board Regular
Joined
Mar 31, 2002
Messages
59
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,483
Office Version
  1. 365
Platform
  1. Windows
No better than the others, but slightly different:
="Your total will be $"&FIXED(A1,2)&" plus tax"
 

Watch MrExcel Video

Forum statistics

Threads
1,118,287
Messages
5,571,318
Members
412,382
Latest member
Langtn02
Top