Reference another cell and make the value positive 1

[bazil2]

(Elementary user)

Spread-sheet #1 has a value in cell B18 of: -3,816,123

I would like to display this value in Spread-sheet #2 in cell C24 as: 3,816,123

Is there a way of doing this?

Best regards

 

[1726]

Use a formula of the form

=ABS(cell)

For cell in same worksheet: =ABS(B18)

For cell in different worksheet: =ABS(sheetname!B18)

For cell in different file: =ABS([filename]sheetname!B18)

If file is stored in a different folder the [filename] should include the full path to the file.