View Single Post
  #2   Report Post  
Michael
 
Posts: n/a
Default

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?