Retain "Thousands format" when concatenating cells

Julia C Peterson

Hello,

I have two cells, "Amount Requested (local)" and "Local Currency Type" that I want to be concatenated in a single cell. I want the amount requested to retain the "," that is added by using "thousands" formatting

Here is my current formula, is there anything I can change it to so that it spits out "980,425 Euro" instead of "980425 Euro"? Applying thousands format to my new formula column doesn't work.

Antonio Figueroa

In your amount requested Please add an '

so when you type in the amount each time type it like this. '986,369

this ' will not show up in the cell but the number in the column will move to the left making it text and not a number.

Now you can use your formula

Julia C Peterson

Hi Antonio,

Thanks for the idea, but it's not working unfortunately

In the first "Amount Requested (Local)" cell, I added this:

And this is the result

Antonio Figueroa

Yes but you have to put the , in the number as well

Antonio Figueroa

should look like this '980,425

Antonio Figueroa

Did this work

Julia C Peterson

Oh I see. Yes it works if I remove the thousands formatting and manually do the formatting of the comma myself, but the data is brought in from datauploader/excel daily without the formatting