View original (French)

Excel: Convert a negative number to positive

Solved
maxwell -  
 Kikou -
Hello,

I am looking to convert negative results to positive so that the "-" sign does not appear in the mail merge I am doing from my Excel table. I tried using the function = TEXT(CELL NUMBER, "#,##"), but it doesn't work...
Thank you for your help

M

3 answers

  1. tessel75
     
    Hello,
    Try using the formula "ABS" 

    =ABS(Cell1)

    Have a good day
    23
    1. Kikou
       
      Thank you so much.
      0