MS Excel codes

Closed
mike - 12 Sep 2008 à 07:20
 Sowmya - 21 Jan 2009 à 21:38
Hello,
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!
Related:

3 responses

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

try to see the help on the forum abour macros you might be able to do it through macros
aquarelle Posts 7181 Registration date Saturday 7 April 2007 Status Moderator Last seen 14 February 2026 491
12 Sep 2008 à 15:59
Hello,
Could you explain which cells are added together and where the formula is placed?
Best regards
Hi,

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).