Converting values to positive or negative in a row

[kv-defy]

	XX	XX	XX	XX	XX	XX	XX	XX	XX
E1	-2	-5	-59	-2	-10	-29	-56	-172	-501
E2	2	3	4	1	5	2	5	1	2

Above in the original table and I would like to change E1 to positive and E2 to negative. I know how to do it for columns but i have a lot of columns so is there a quicker way to convert the rows into negative/positive values faster?

Desired outcome:

	XX	XX	XX	XX	XX	XX	XX	XX	XX
E1	2	5	59	2	10	29	56	172	501
E2	-2	-3	-4	-1	-5	-2	-5	-1	-2

[DataNath]

Hey @kv-defy, you can use the Multi-Field Formula tool to handle all of the columns at once! Workbook attached.

[kv-defy]

Thank you so much but my values are huge and converting them into a double or other form will distort the values given. Is there any other way?

[DataNath · Accepted solution]

Not sure what you do with these numbers downstream or if you just need them converting for a view, but you could just keep them in string format to show the whole number. Double is the largest numeric data type but will still convert larger numbers into scientific notation. If these numbers will always be within a specified limit/degree of accuracy then you could convert to a FixedDecimal but if not then I'm not aware of any way to keep the full display and make them numeric. Have included a large number in this example (using the string method) just to show it working:

[grazitti_sapna · Accepted solution]

@kv-defy, another solution to your problem.

Thanks!

[Kurohits · Accepted solution]

Hi @kv-defy 

Pretty easy with Multi Field formula tool. I have attached 2 methods. One is long and another is just one tool and job done. Check out and let me know if you need any further help. 

Thanks 

Rohit Gupta