View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
YESHWANT YESHWANT is offline
external usenet poster
 
Posts: 41
Default Limiting the number of characters in a cell

Hi smartgal,

you can do the same thru :
open your excel file, click on data - validation - in the setting tab, in
"allow" field select "text lenth" - data field "not equal to" - length field,
enter the desired length - On the "error alert" tab, Style field "Stop" -
Enter your appropriate message in Title and error message fields - click OK
and your job is done.

click yes below, if it helps


"smartgal" wrote:

Isn't there a way to define the number of characters a cell will allow? Our
operating system has fields that have defined character lengths, we need the
form our folks fill out to have the same limits.

Thanks!