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 réponses

Réponse 1 / 3
tessel75
 
Hello,
Try using the formula "ABS" 

=ABS(Cell1)

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