Find/Replace Select Numbers in a Cell

S

SRM

I have Excel 2003. Below is what I use to enter costs for each month
in one cell. At the end of the year, I then change the values back to
zero for the next year. I understand I can do this using different
configurations, but I was wondering if it was possible to change any
none zero values back to zeros using Find/Replace or some other means.
For example, change "111+5678+4645", "2345+4567", and "100" all to
zeros in a find and replace. Right now I select the none zero values
and change them to zero. This is all manual.

=N("January")+(0)+N("February")+(111+5678+4645)+N("March")
+(0)+N("April")+(0)+N("May")+(2345+4567)+N("June")+(100)+N("July")
+(0)+N("August")+(0)+N("September")+(0)+N("October")+(0)+N("November")
+(0)+N("December")+(0)

Thanks.

Shawn
 
D

Dave Peterson

If this is just a single cell, then I would create the "master" formula and plop
it in an out of the way cell (on a hidden sheet????).

Then just copy|paste that master formula into the real cell.
 
D

Don Guillett Excel MVP

If this is just a single cell, then I would create the "master" formula and plop
it in an out of the way cell (on a hidden sheet????).

Then just copy|paste that master formula into the real cell.

"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."
 
S

SRM

"If desired, send your file to dguillett  @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."

Thanks for the help and feedback. I appreciate the help. Probably just
going to go with the idea of a master formula and copy it as needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top