Would value 0 in cells that don't need checking suffice. If so another way
to enjoy the odd bit of cake:

Create a Custom number format like this

General;General;"- - -"

positive format ; negative format ; zero format

Enter 0 instead of dashes to indicate no check.

Regards,
Peter T


Well, I've worked it out. Recently, because I occasionally enter --- to
indicate no check number for things like deposits, I formatted the column
as Text to eliminate the apostrophe and that affected manually typed in
check numbers that 'threw' the Worksheet_Change event. Formatting back to
General fixed things. Can't have my cake and eat it, too <sigh.

--
David