View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default How do I make a cell allow only 24 alpha/num. char.to be entered

Fred,

Select the cell, choose DAta / Validation... Under "allow" choose "Text lenght" and the "equal
to" and 24....

HTH,
Bernie
MS Excel MVP


"Fred@JFK" wrote in message
...
I have a field that will only take 24 alpha/num. char.. How can I limit data
entered into a cell to 24 char. without having to count char.