Hi Malcolm

One more way:

1. Enter -1 (negative one) in some cell.
2. Copy the cell.
3. Select all numbers in the column in question.
4. Choose Edit Paste special and "Multiply". OK
5. <Esc (To unselect the -1 cell) and clear it.

--
Best Regards
Leo Heuser
Excel MVP

Followup to newsgroup only please.

"Malcolm" skrev i en meddelelse
...
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