Concatenate text & number cell

J

John

Hi all,
I need to concatenate a word and a number cell. eg,
Concatenate("Limit = $",A1) where A1 = $100,000. It shows
up like this: "Limit = $100000". However I want the
number to format with the comma between the thousand,
ie. "Limit = $100,000"

Does any one know how to do this. Thanks in advance.

regards,

John.
 
N

Norman Harker

Hi John!

Try:
=CONCATENATE("Limit = ",TEXT(A1,"$#,###"))
Or:
=CONCATENATE("Limit = $",TEXT(A1,"#,###"))
 
D

Dave Peterson

Another way is to give it a custom number format:

"Limit = " $#,##0

Format|cells|number tab|custom category.

The cell will still be numeric and you can do further arithmetic easily.
 
Top