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.
|