View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Big Abalone
 
Posts: n/a
Default Is there a way to only have certain things typed into a cell?



"Big Abalone" wrote:

Is it possible to have only "P3 000" the "0" means any digets, not more than
3 tho. be the only thing able to be entered? What I mean is I only want some one to be able to enter "P3 and then one , but not more than 3 digits. For example P3 111 or P3 2, or P3 45. It is for a template for my dive spots.