How to retain number format while doing concatenate

[ThrottleWorks]

Hi,

I am trying to concatenate multiple cell values with formula.

I need to retain number format while doing concatenate.


For example

A1 = Sample Text

B1 = 1,001.10

C1 = A1&"-"&B1


C1 value is being populated as Sample Text-1001.1 I want it to be populated as Sample Text-1,001.10.

I do not know how to do it. Can anyone please help me in this.


My sincere apologies for not uploading sample file.

 

[Hui]

=A1&" - "&TEXT(A2,"#,###.00")

 

[ThrottleWorks]

Hi @Hui Sir, thanks a lot for the help. It's working perfectly. Good night.