convert negative positive

  1. C

    Macro to Convert all the data in column in Negative Value

    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. Sub Cnegative() ' ' Cnegative Macro ' For Each...
  2. R

    Convert Negative Value to Positive

    I have the number -50 in cell: H21, which is the its formula which reads as below: =SUM(H20-H19) My wonder is how / if I can automatically always convert whatever is in that cell to a positive number vs. a negative? Thanks, Rick

Some videos you may like

This Week's Hot Topics