Need to convert the result of a formula (simple number) to a number with thousands separator commas

[Loreleii7]

Hi everyone!!


I'm having an issue here.
I've used a formula combining CONCATENATE and IF functions and the results are pulled from another sheet. They're numbers and they were originally entered as simple numbers (i.e. 1000) and then the cell were converted to 'comma style" in order to separate the thousands (1,000). The problem is when pulling those cells into the result of my formula, they doesn't include the commas. I tried converting the cell with the formula to currency or applying the comma style but any of them worked.


I've also tried the DOLLAR function, but it includes the $ sign and it's not supposed to show (I mean, I don't want to include it on these cells)... do you guys know how to hide the $ sign in the DOLLAR function or how to convert my number result '1000' to '1,000' (no decimals nor $ sign)??


Thanks a lot!!

 

[VoG]

You can use the TEXT function like this

=A1&TEXT(Sheet1!A1,"#,##0")

 

[Loreleii7]

Yes!! It worked!!
Thank you very much for the quick and helpful response