Need help with Format Excel Activity

[V_Roboto_V]

Hi @SenorChang

I had solved a similar query on converting a DE format decimal to Global. Could you check it:

Conversion de dato

That will not work. Here is a fix, put this code in the Invoke Code: Try ' Try converting the input string using the German (de-DE) culture inputString = CInt(Convert.ToDecimal(inputString.Replace("$", ""), System.Globalization.CultureInfo.GetCultureInfo("de-DE"))).ToString() Catch ex As Exception ' If an exception occurs, check if it's the exception case (last comma before the last two digits) If inputString.LastIndexOf(",") = inputString.Length - 3 Then ' Replace the …

Do customize it to your needs.