HI All ,
I have written below code for converting all the numbers in the column to negative value however if some text comes in between my macro is not running can any one help me also the macro should run in all the sheets in that workbook.
' Cnegative Macro
I have the number -50 in cell: H21, which is the its formula which reads as below:
My wonder is how / if I can automatically always convert whatever is in that cell to a positive number vs. a negative?