This is a discussion on Concatenate number with text, but keeping in number format within the Excel Questions forums, part of the Question Forums category; I am concatenating two fields in Excel using an '&' sign, where one is a number and one text. For ...
I am concatenating two fields in Excel using an '&' sign, where one is a number and one text.
For example, using the formula =A1&A2 where
cell A1 contains 'that costs '
and cell A2 contains $50,000
I want to display the sentence 'that costs $50,000'
but instead it converts the number to text to display 'that costs 50000' which is no good to me.
How can I simply set it up to display the '$' and the ','?
Use the TEXT function to instruct Excel the format to use (currency):
=A1 & TEXT(A2,"$#,##0")
TIPS FOR FINDING EXCEL SOLUTIONS
1. Use the built-in Help that comes with Excel/Access
2. Use the Search functionality on this board
3. A lot of VBA code can be acquired by using the Macro Recorder.
"Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"