Format a Concatenate?

Hi,

I have using the & to Concatenate in Excel. If I do this: "&D3&", I get the value in the referenced D3 cell, which is great, but if D3 is a number (let's say $5,000), that number comes across as 5000 (no formatting). I have looked online on how to format, but everything I saw was for using the =CONCATENATE function, not the & reference. Anyone know how to modify formatting to a $ or %?

don't know what you are trying to concatenate D3 with but to get the $5,000 you can incorporate this into the formula...
&TEXT(D3,"$#,###")

I'm trying to figure out what you are trying to...
a) get as the final result and
b) what you are concatenating it with.
I also don't understand what you mean by "grab the referenced cell data in D3"
can you post a sample workbook using the instructions at the top of the page, just a couple rows showing what you have AND the results you expect?

try this if I'm understanding your request and example correctly...
="This is test text "&TEXT(A1,"$0,000.00")

I don't remember the last time I used the concatenate formula because the ampersands do the same thing.
So reading post #7 and looking at your uploaded workbook, I'm back to not being clear about what you want.
If you are looking for "test text here "&F3&" test text here"
then perhaps this? ="This is test text "&TEXT(F3,"$0,000.00")&" test text here" that will give you the same results as what you wrote in post #7.

You're welcome, glad I could help!