DQ1 Wrote:
Mental block. Isn't there any easy way to fill all empty cells with
"0"'s?

Hi DQ1

You can enter a single zero just by typing into the cell, to enter
multiple 0's either enter a ' first, or format the cell as text first
and the enter as many 0's as you like


--
Paul Sheppard


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