Combine 2 different number cells with thousands separator

[bullit_nl]

Hello,

I want to combine 2 cells with numbers and keep the thousands separator.

A1 = 1.500
B1 = 3.000

Result in C1 with =A1&" - "&B1:
1500 - 3000

I want the result look like this
1.500 - 3.000

Is this possible?

Thank you.

 

[Aladin Akyurek]

Something like...

=TEXT(A1,"#,##0")&" - "&TEXT(B1,"#,##0")

in American formatting.

Perhaps it's

=TEXT(A1;"#.##0")&" - "&TEXT(B1;"#.##0")

in European formatting.

 

[bullit_nl]

Hello Aladin,

Thank you for your quick reply. This worked perfectly.

 

[Aladin Akyurek]

Hello Aladin,

Thank you for your quick reply. This worked perfectly.

Mooi. You are welcome.