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

Help Activities
,
1

How can I transfer the minus sign of each value in columns if the number is negative. Any input are appreciated. Tnx

SS
SS1648×414 8.1 KB

SampleTable.xlsx (10.2 KB)

2

Hi,

Can you try the following sample?

image
image997×2078 137 KB

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,

1 Like
4

It worked! Thank you for the help!

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.