lburg801 Wrote:
I appreciate having two options. Surely one will work!

I have a question about Option 1. There are no fields on this worksheet
where a single zero would be input. Is it the occurrance of a single
zero that the option addesses, and not cells containing phone numbers
and addresses that might include zeros?

Thanks,
Trudy :)

Hi Trudy


Option 1 will only supress a single zero, so zero's contained with
other data are safe


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=480045