View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Cutter
 
Posts: n/a
Default Limiting the number of characters in a cell. How?


Take a look at:

Data Validation

On the Settings Tab click on the "Allow:" drop down and choose Text
Length

Then go to the other tabs to set your message(s)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=500673