If you concatenate a number cell with a text cell, the result is a text cell. A cell can have only one format.
You can certainly concatenate the two cells as you describe, but the cell will be recognized as a text string.
If A1="$1000.00" and B1="ABC Company", you can concatenate in C1 with formula:
=A1 & Char(10) & B1
HTH
Dan --
Does
=TEXT(A1,"$#,##0.00_);($#,##0.00)")&CHAR(10)&B1
not work? [ I don't see the effect of CHAR(10) on my Mac, whence my question. ]
Aladin
========
Yes, that is the correct way to write it.
Char(10) is the ANSI code for a hard break on PC's. I thought is was the same in Mac's as well. When I use the formula you gave below I get the desired hard break.
Thanks for verifying it Dan. On the Mac: I dunno. Still not working. Even after a combination of CHAR(13) and CHAR(10), I need to check Wrap text to get the desired effect. Just weird.
Aladin
=======