Previous Topic Next Topic

MS Excel codes

Closed
mike - Sep 12, 2008 at 07:20 AM
 Sowmya - Jan 21, 2009 at 09:38 PM
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

Answer 1 / 3
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
Answer 2 / 3
aquarelle Posts 7180 Registration date Saturday April 7, 2007 Status Moderator Last seen December 19, 2024 491
Sep 12, 2008 at 03:59 PM
Hello,
Could you explain which cells are added together and where the formula is placed?
Best regards
Answer 3 / 3
Sowmya
Jan 21, 2009 at 09:38 PM
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).

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses