Hi, In my working sheet, the column name is “Amount” and it holds number in positive as well as negative. -I am trying to convert all the -ve numbers in that column to positive as I have to compare those data with another data. -I am reading the full excel sheet and storing it in a DT, so how can…

Convert negative string to positive in Excel without using Loops

Priyanka_Ramesh (Priyanka Ramesh) March 12, 2020, 10:13am 8

How to drag a formula in the entire column in excel - #2 by ClaytonM
Can you try this. Even in Linq the For loop has to be used .

1 Like

Topic		Replies	Views
I want to change all negative values of a column to 0 Help datatable , activities , question	9	1978	October 3, 2023
How do I convert numbers to negative numbers? Learn excel	7	2730	June 14, 2020
Convert DT Row Item to Negative Value Studio datatable	3	1431	August 21, 2020
Turning a negative value to positive Academy Feedback datatable , excel , studio , question	8	5401	June 28, 2022
How to turn negative value in excel into a positive one Learn	4	858	July 16, 2020