Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BruceY BruceY is offline
external usenet poster
 
Posts: 3
Default Data Validation

HI,
I would like to limit input to all cells within a column to the following;
cannot be more then 9 digits with the first two always being "NJ" and the
last 7 numeric including 0.

Anything other then this should generate an error message.

Any help would be gratly appreciated.
--
Bruce