View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Malcolm Malcolm is offline
external usenet poster
 
Posts: 5
Default Formula to change Negative numbers to positive

Hi

I have a column of data that shows all numbers as negativie numbers.

Is there a formula I can write that can be dragged down the column to change the negative numbers into positive numbers?

For example, if a cell contains -500.00 I would like to convert that number to 500.00

Regards

Malcolm Davidson