How do you remove sign from spread sheet?

Answer 1

If you mean to show a number without a positive or negative, like showing the difference between two values you can use the ABS function. So both of these will show 9:

=ABS(10-1)

=ABS(1-10)