View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Change from a negative to a positive

You want the absolute value.

=ABS('Other W'!B19)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Erica" wrote:

I am working on a buget and need to use the information from one sheet
carried over to another sheet. On the original sheet it is considered a
negative number but I need it carried over as a positive number. The formula
I am using is:
=+'OTHER W'!B19

Thank you!