Formatting a number within a sentence

Is there a way to format a number within a sentence? i.e.

In cell A1 I have 2,000 entered and formatted as a number. In cell A2 I type in ="How can I format "&A1&" ?"

When I do this, the result in A2 is How can I format 2000?

Is there a way to format the 2000 to show the thousand separator comma? If the number were -2,000 instead, is there a way to show both the comma and parentheses around the number? (without putting the parentheses manually into the formula)?

Thanks in advance

With use of the TEXT function you can definetly do what you are looking to do.

Please Login or Register  to view this content.

Hope that helps...
John

Try:

="How can I format "&TEXT(A1,"#,###")&" ?"

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save