Macro to replace negative numbers by 0
you could format the cells to "0.00;;" which would hide neg and zero values
--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Bill" wrote in message
...
Hello
May I please ask for your help? I have just completed an
extensive Google Groups search, but I couldn't find any
posts that dealt with this problem.
I have many large documents. I need to replace all
negative numbers found in these documents by zeros [0].
If these negative numbers were all the same number, I
would have done "find/replace", but these negative numbers
are all different...
Is it possible to write a macro that could be run to
replace all negative numbers [in the active work sheet] by
0's?
I would be very grateful for any help and all suggestions.
Sincerely
Bill
|