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!

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 <atyahoo<dotcom
----
"Laura@Gage" wrote in message
...

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

Hi Max,
I'm sorry about the double post. I'm new to this and thought I went to the wrong place. Thanks for all of your help



QUOTE=Laura@Gage]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![/quote]

You're welcome, Laura !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Laura@Gage" wrote in message
...

Hi Max,
I'm sorry about the double post. I'm new at this and was concerned I
went to the wrong place for my question. It won't happen again.
Thanks for all of your help.
-Laura