keep $ formatting when concatenating
 

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?

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?

Try

=A1&" "&TEXT(B1,"$#,##0.00")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"danielo" wrote in message
...
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?

That'd work, but not for what I'm doing. I'm pulling in B1 from anther
sheet, and need to NOT modify it.... Thanks for the suggestion, though!

"Michael" wrote:

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?

danielo

=A1 & " " & TEXT(B1,"$#,##0.00")


Gord Dibben Excel MVP

On Mon, 7 Feb 2005 13:35:06 -0800, "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?

OK
Well how about putting in an extra column, say D1, formatting as text and
using the formula =B1.
Hide that column and then put the formula in C1 =A1 & " " & "$" &D1
You can then copy down as far as needed.
This is probably a bit messy........but !!
HTH
Michael

"danielo" wrote:

That'd work, but not for what I'm doing. I'm pulling in B1 from anther
sheet, and need to NOT modify it.... Thanks for the suggestion, though!

"Michael" wrote:

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?

Gord and Peo - THANK YOU! That works like a charm.

"Peo Sjoblom" wrote:

Try

=A1&" "&TEXT(B1,"$#,##0.00")

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"danielo" wrote in message
...
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?