Hi Danielo
Format B1 as text and type in your dollar amount manually.
HTH
Michael
"danielo" wrote:
Here's a sample of my data:
A1: Building A
B1: $36,456.00
C1: =A1 & " " & B1
But C1 returns: Building A 36456
And what I want is this: Building A $36,456.00
In other words, the concatenation dumps the "currency" formatting in cell
B1, but I want to KEEP that formatting.
Can I do that?
|