Thread: how to change cell sign and values
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
simora simora is offline
external usenet poster
  
Posts: 7
Default how to change cell sign and values
Great!

Thanks.



Nick Hodge wrote:

In the next column, say B, enter =-B1 and copy down.

This will reverse the sign and leave zeroes un-affected


Reply With QuoteReply With Quote