How do I replace a negative number with zero

L

Laura@Gage

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


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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I replace a negative number with zero 0
Rounding Negative Numbers to Zero 4
formula to a minimum value of zero if a negative number 2
Adding recognised Zeros 5
convert negative numbers to a zero 10
How do I replace a negative number with zero 2
How do I replace negative numbers with zero in Excel. 1
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top