Efficient method or query to replace

[Sonalk (Sonal)]

If multiple columns contains negative numbers then Replace “-” with (number).
Example

A B C D
0 -24.45 0 2.45
-11 0 0 0

Expected output
A B C D
0 (24.45) 0 2.45
(11) 0 0 0

[Yoichi]

Hi,

Can you try the following sample?

row(col) = "("+row(Col).ToString.TrimStart("-"c)+")"

Sample20230405-3L.zip (8.6 KB)

Regards,

[Sonalk (Sonal)]

Thanks @Yoichi for your solution.