How to convert string with comma separated value

[Anil_Potekar]

I have input excel file contains amount column values like 1234.56 or 1234.00 or 1234 or 1,000.99 etc… any random values

I want to convert any amount into ‘1,234.56 Cr.’ this format i.e. amount with comma separated with end with Cr…

how can I implement this logic.

[fernando_zuluaga]

Hi @Anil_Potekar

give a try with the following

Double.Parse(strInput).ToString("#,##0.00") + " Cr."

Regards

[Suraj_B_Shetty (Suraj)]

Hi @Anil_Potekar
Try this.

Sample Workflow
Format.xaml (5.5 KB)