Concatenate text & number cell

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

 

[JE McGimpsey]

one way:

="Limit = " & TEXT(A1,"$#,##0")

 

[Norman Harker]

Hi John!

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

 

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