Want to limit input to cell to 16 characters.
J JE McGimpsey Sep 28, 2005 #2 Choose Data/Validation; Allow: Text length; Data: less than or equal to; Maximum: 16. Note that this will not stop the user from entering more than 16 characters, but 17 or more will bring up an error dialog.
Choose Data/Validation; Allow: Text length; Data: less than or equal to; Maximum: 16. Note that this will not stop the user from entering more than 16 characters, but 17 or more will bring up an error dialog.
G Gord Dibben Sep 28, 2005 #3 Data>Validation>Allow>Text Length Minimum 0.....Maximum 16 Add your own Message if desired. Gord Dibben Excel MVP
Data>Validation>Allow>Text Length Minimum 0.....Maximum 16 Add your own Message if desired. Gord Dibben Excel MVP
