MS Excel codes

Closed
Report
-
 Sowmya -
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!

3 replies

Posts
10
Registration date
Sunday August 17, 2008
Status
Member
Last seen
April 1, 2009
5
hey there,

try to see the help on the forum abour macros you might be able to do it through macros
1
Posts
7099
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
January 20, 2022
490
Hello,
Could you explain which cells are added together and where the formula is placed?
Best regards
0
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).
0