Hi Malcolm

If your negative is in A1 then put this in B1:
=ABS(A1)

Now you have a negative in A1 and its positive in B1.

I may misuderstand your question, but anyway: A cell can contain a formula
OR a value, so you can not enter a formula in A1 that does something with a
value in A1.
--
HTH. Best wishes Harald
Followup to newsgroup only please

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