It works great thanks.

"Gord Dibben" wrote:

Check out DataValidationAllow.


Gord Dibben MS Excel MVP

On Sun, 29 Oct 2006 20:31:01 -0800, Joseph
wrote:

Hi,
I want to restrict entries to numbers only in some cells that are related to
a formula, is it possible to format a cell for numbers and not alphabet ?

thanks