One way might be to use a helper col,
then point all downstream calcs to it

If orig. col is col A, with data/formulas in row2 down

Put in B2: =MAX(A2,0)
Copy B2 down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Laura@Gage" wrote in message
...

Hi,
I need to replace all negatives in a column with zero. I'm running
into a problem because one, not all numbers in that column are
negative, and two, I already have functions that have to stay in the
cells. Is there anything that I can do with formatting or can I have
more than one function in a cell...and if so, what function?
Thanks!!!


--
Laura@Gage