Retain cell format while linking cells
 

I need some help here. I would like to link some cells together. Some
cells contain text, others contain currency. For Example:

A1 A2 A3
You owe me $10,000.00 Dollars!

I would like this to happen:

A5
You owe me $10,000.00 Dollars!


Linking cells doesn't work, I have read all over that it can be done
with VB. Except, there is no examples of what code would do this. I
would like help writing this simple (not for me) scenario, I could
make it work for what I need after that.

Thanks,
Josh

Retain cell format while linking cells
 

Hi Josh
try the following
=A1 & " " TEXT(B1,"$#,##0.00") & " " & A3

HTH
Frank

Josh wrote:
I need some help here. I would like to link some cells together.
Some
cells contain text, others contain currency. For Example:

A1 A2 A3
You owe me $10,000.00 Dollars!

I would like this to happen:

A5
You owe me $10,000.00 Dollars!


Linking cells doesn't work, I have read all over that it can be done
with VB. Except, there is no examples of what code would do this. I
would like help writing this simple (not for me) scenario, I could
make it work for what I need after that.

Thanks,
Josh

Retain cell format while linking cells
 

Think Frank meant:

In A5 put this formula:

=A1 & " " TEXT(A2,"$#,##0.00") & " " & A3

--
Regards,
Tom Ogilvy


Frank Kabel wrote in message
...
Hi Josh
try the following
=A1 & " " TEXT(B1,"$#,##0.00") & " " & A3

HTH
Frank

Josh wrote:
I need some help here. I would like to link some cells together.
Some
cells contain text, others contain currency. For Example:

A1 A2 A3
You owe me $10,000.00 Dollars!

I would like this to happen:

A5
You owe me $10,000.00 Dollars!


Linking cells doesn't work, I have read all over that it can be done
with VB. Except, there is no examples of what code would do this. I
would like help writing this simple (not for me) scenario, I could
make it work for what I need after that.

Thanks,
Josh

Retain cell format while linking cells
 

Thanks Tom for pointing this out (copy and paste error....)
Regards
Frank

Tom Ogilvy wrote:
Think Frank meant:

In A5 put this formula:

=A1 & " " TEXT(A2,"$#,##0.00") & " " & A3

Retain cell format while linking cells
 

"Frank Kabel" wrote in message ...
Thanks Tom for pointing this out (copy and paste error....)
Regards
Frank

Tom Ogilvy wrote:
Think Frank meant:

In A5 put this formula:

=A1 & " " TEXT(A2,"$#,##0.00") & " " & A3



Thankyou, Thankyou!!! I was tricked there for a little, there was an
& missing from the formula.

here is what it is
=A1 & " " & TEXT(A2,"$#,##0.00") & " " & A3
You guys rock though! Thanks for replying so fast, I would have never
figured it out

Josh