Haydon Waldek
New Member
- Joined
- Jan 25, 2006
- Messages
- 2
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 ','?
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 ','?