Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,441
Default validation controls in excel

Use Data Validation with the Text Length option chosen, and set the Min and Max to the same value.

HTH,
Bernie
MS Excel MVP


"harini 04B01A0503" wrote in message
...
Can I get a formula fr applyin a validation control on a cell which
accepts alphanumeric values with specified text length..its abit
urgent fr me..im new to this whole environment...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Controls not available in Excel. Infoman Excel Discussion (Misc queries) 0 November 20th 07 07:16 PM
Controls in Excel 2007 Pat Excel Discussion (Misc queries) 1 August 20th 07 05:02 AM
Form controls in Excel 07 New to Excel 07 Excel Discussion (Misc queries) 1 July 30th 07 04:43 PM
ActiveX Controls vs Form Controls Alex Excel Discussion (Misc queries) 1 January 11th 06 08:46 AM
Help on Excel controls Reney Langlois Excel Discussion (Misc queries) 1 March 9th 05 02:48 PM


All times are GMT +1. The time now is 02:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"