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
1
Answer 2 / 3
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 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
0
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).
0

Similar discussions

Can't login to Facebook attempted too many code entries
Umair -
HelpiOS -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses