Keep proper cell format

Hi,

I have an excel file.
In need to have in column G, values which are not negative. In means delete “-”
However I need to keep an original format of cells


EXPORT.XLSX (38.0 KB)

Hi,
Could you please use find and replace method.
Thanks
Regards
Sahad KK

Hi!

try like this:

1.Assign

LHS: Total type (String)
RHS: CurrentRow(“ColumnName”).ToString.Trim

2.Assign

LHS: Total
RHS: CInt(Total).ToString.Replace("-","").ToString

Regards,
NaNi