Excel 2007 replace

[Jim WV]

Advance warning, this is a rant, and I apologize in advance since I know there are some really great users/contributors in here.



I simply cannot believe that a simple replace (blank cell with a 0) operation that worked wonderfully in prior versions chokes in Excel XP 2007! I know there is probably a work around that works, and that I have found before but I can't remember now, but for the L.O.G. and for all that is holy, why . Tell me the workaround and I will be happy with that, but my beef remains!

I have used Excel/Word/Access for close to 15 years and consider myself somewhat of an expert, IMO. When I'm in full swing I daresay it is difficult for any processor to keep up with me, and now in major analysis mode I'm all PO. I'll try and take a deep breath and export Access query as text and work from there, sigh.

Thanks for listening, I feel better now, and have a great day!

Despite my rant I have advanced greatly in my field via Access to Excel to analysis programs such as R. I am suitable grateful to these powerful programs, since I can remember 5 1/4 floppies. Are the newer versions of Excel subject to this?

Jim
Very Frustrated Yet Grateful
WVU
Morgantown
WV