I want to set comma into numbers in an excel file using UiPath

For example:

I have this datatable

imagen

But I want to have this format:

imagen

Use this below code, @ahmadLH
String.Format(“{0:n}”, -589456.36) and update the datatable using for each row using assign activity.
For example, row(“ColumnName”) = If(row(“ColumnName”).ToString.Trim.IsNumeric,String.Format(“{0:n}”,row(“ColumnName”).ToString.Trim),“0”)
Hope this may help you :slight_smile:

It didn’t work