How do I combine dollars and text
 

I want to combine two different cells that contain dollars and text. when I
try it always drops the $ sign. How do I do this? Example cell A2=$40 and
cell A3 is per year, I want in one cell $40 per year.

How do I combine dollars and text
 

I suspect the $ sign in a2 is a format so try this

=TEXT(A2,"$"&0)&" "&A3

Mike

"Kesbutler" wrote:

I want to combine two different cells that contain dollars and text. when I
try it always drops the $ sign. How do I do this? Example cell A2=$40 and
cell A3 is per year, I want in one cell $40 per year.

How do I combine dollars and text
 

="$" & A2 & " " & A3
--
Gary''s Student - gsnu200804

How do I combine dollars and text
 

these both get me the $ but now they drop the comma's for larger numbers like
$4,000,000 and I am working with millions so I need it.

"Gary''s Student" wrote:

="$" & A2 & " " & A3
--
Gary''s Student - gsnu200804

How do I combine dollars and text
 

=TEXT(A2,"$#,##0") & " " & A3

This formula makes no cents.
--
Gary''s Student - gsnu200804

How do I combine dollars and text
 

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


Gord Dibben MS Excel MVP

On Thu, 11 Sep 2008 07:38:00 -0700, Kesbutler
wrote:

these both get me the $ but now they drop the comma's for larger numbers like
$4,000,000 and I am working with millions so I need it.

"Gary''s Student" wrote:

="$" & A2 & " " & A3
--
Gary''s Student - gsnu200804