--Getting rid of negatives

C

CLR

You could put -1 in a spare cell and click on it and do Copy, then highlight
your cell with the formula and do Paste-special > Multiply

Vaya con Dios
Chuck, CABGx3
 
M

Mark E. Philpot

Hi...

You could try Format > Cells > Number: Custom

Custom the cell formatting to:

#,##0;#,##0

as the second part refers to negatives, omitting the minus
sign means your negative numbers will only show as
positive numbers but still retain their negative value!

regards
Mark E. Philpot
 
Top