Mike,

One way to do this is through Data validation (DATA Validation)


In the cell where you want the numbers or 0 to be go to data
validation

Select list then in the box put =IF(Cell_that_has_H="h",0,1,2,3,4,etc)

This will only allow 0 to be entered into the cell when H is selected,
make the list of numbers as long as you like/need or you could use a
named range.

Not all that pretty but it works.

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=547423