How do I replace a negative number with zero

Hi,
I need to somehow replace all of the negative numbers in one column
with zero. I am having issues because I already have a function in the
column that I need to do this with. Maybe something with formatting?
Please help. And thanks!


--
Laura@Gage

If you can use a helper column of formulas, you could use a formula like:

=max(0,a1)

And drag down.

If you can't use that helper column, you could apply Data|filter|autofilter

Then filter that column to show the values less than 0.

Then select those visible cells
type 0
hit ctrl-enter to populate all the visible cells.

data|Filter|show all data
or
Remove the filter

"Laura@Gage" wrote:
>
> Hi,
> I need to somehow replace all of the negative numbers in one column
> with zero. I am having issues because I already have a function in the
> column that I need to do this with. Maybe something with formatting?
> Please help. And thanks!
>
> --
> Laura@Gage

--

Dave Peterson

You've got at least one response
in your (almost) identical post in .newusers
(Please do not multi-post)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Laura@Gage" <[email protected]> wrote in message
news:[email protected]...
>
> Hi,
> I need to somehow replace all of the negative numbers in one column
> with zero. I am having issues because I already have a function in the
> column that I need to do this with. Maybe something with formatting?
> Please help. And thanks!
>
>
> --
> Laura@Gage