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