MS Excel codes

mike - Sep 12, 2008 at 07:20 AM
 Sowmya - Jan 21, 2009 at 09:38 PM
I am having a problem about MS Excel. What codes should I type if I need to replace all cells with negative sums with ZERO (0)?
Please help me in this matter. Thank you!

3 replies

lostseasons Posts 10 Registration date Sunday August 17, 2008 Status Member Last seen April 1, 2009 5
Sep 12, 2008 at 10:05 AM
hey there,

try to see the help on the forum abour macros you might be able to do it through macros
aquarelle Posts 7120 Registration date Saturday April 7, 2007 Status Anonymous Last seen April 14, 2023 490
Sep 12, 2008 at 03:59 PM
Could you explain which cells are added together and where the formula is placed?
Best regards

Please use Replace, Edit Menu>>Replace. In Find what give the Negative Nos. which you want to replace and in replace with Type Zero(0).