View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Smith NC Mike Smith NC is offline
external usenet poster
 
Posts: 9
Default Limit Digits entered into a cell

I have a cell that users enter a 3 digit number and another a date, both are
used to generate a serial number. Is there a way so that if a user enters
more than 3 digits an error message comes up and it doesn't update to the
serial number cell? Thanks for any help