How to set amount format in excel with separator

[nfa (robotautojunior)]

Hi All,

I have problem with the amount format in my excel.

Value A that I have stamped in Excel. Somehow it stamp without (,) as separator even though I have formatted it in Excel. Expected should be 49,717.53 with (,)

I need to compare/match with variable B which i get from other system: Value as below

Anyone know how to set the format so that i can match/compare the value A and the variable B.

[Lak_Ui (Lakshmi)]

Try this Convert.ToDecimal(“49717.53”).ToString(“#,##0.00”)