Use the Read Range activity to extract the data table from the website and store it in a variable, let’s say dtData.
Add a ForEach Row activity and set the Input property to dtData.
Inside the loop, add an Assign activity to modify the format of the “Balance” column.
Left side: row(“Balance”)
Right side: “-” & Math.Abs(Double.Parse(row(“Balance”).ToString())).ToString(“#0.00”)
The above expression converts the value of the “Balance” column to a Double, takes the absolute value, adds a “-” sign, and formats it with two decimal places.
4. After the ForEach Row activity, you can use the modified DataTable dtData, which now has the “Balance” column values in the desired format.