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.
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.