Search : in
By :

MS Excel codes

Last answer on Jan 22, 2009 2:38:05 am GMT mike, on Sep 12, 2008 12:20:18 pm BST 
 Report this message to moderators

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!

Configuration: Windows XP
Firefox 3.0.1

Best answers for « MS Excel codes » in :
MS Excel, Stripping Out Char(10) Data Show
MS Excel 2007 won't read in 2003 Show
[MS Excel] - Stripping Out Char(10) Data Show [MS Excel] - Stripping Out Char(10) Data Issue I working in Excel with VBA and have 5 or 6 rows of data located within 1 cell. The user has decided to use Alt-Enter whilst entering the data. The data is as follows: Encoding: MPEG 1.0...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Know the Hexadecimal code of a color ShowKnow the Hexadecimal code of a color What is a Hexadecimal code What is a Hexadecimal code In mathematical terms, a hexadecimal (hex) is a numeral system consisting of a base, of 16. It uses sixteen distinct symbols: Numeric symbols:...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL �+ ;� in the chosen cell. To insert current time, press CTRL�+...
MIME (Multipurpose Internet Mail Extensions) ShowIntroduction to MIME MIME (Multipurpose Internet Mail Extensions) is a standard which was proposed by Bell Communications in 1991 in order to expand upon the limited capabilities of email, and in particular to allow documents (such as images,...
Ask your question Reply

1

lostseasons, on Sep 12, 2008 3:05:44 pm BST
  • +1

Hey there,

try to see the help on the forum abour macros you might be able to do it through macros

   
Reply to lostseasons

2

aquarelle, on Sep 12, 2008 8:59:31 pm BST

Hello,
Could you explain which cells are added together and where the formula is placed?
Best regards "Pour trouver une solution � ses probl�mes, il faut s'en donner la peine."

   
Reply to aquarelle

3

 Sowmya, on Jan 22, 2009 2:38:05 am GMT

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

   
Reply to Sowmya
Ask your question Reply
They need your help