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,
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
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