Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete all negative numbers leaving only positive numbers
I have a column containing positive and negative numbers. I need a formula
that will delete all the negative numbers from the list leaving only the positive ones. the list is extremely long so it would help me enormously. I hope someone can help Regards Basil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
How to switch negative numbers to positive numbers in Excel ? | Excel Worksheet Functions | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
How to change a series of positive numbers to negative numbers | Excel Worksheet Functions |