Help! How can I transfer the negative symbol of each value in columns

[Yoichi]

Hi,

Can you try the following sample?

CurrentRow(col) = Double.Parse(System.Text.RegularExpressions.Regex.Match(CurrentRow(col).ToString,"^[\d.,]+").Value,System.Globalization.NumberStyles.Any)*(CDbl(System.Text.RegularExpressions.Regex.IsMatch(CurrentRow(col).ToString,"-"))*2+1)

Sample
Sample20240321-5 (3).zip (11.5 KB)

Regards,