#1   Report Post  
Springwalker
 
Posts: n/a
Default Edit Mask

Is there a way to set up cells so that only a certain amount of numbers can
be entered into that cell or group of cells? Similar to an Edit Mask in
Access.
  #2   Report Post  
bigwheel
 
Posts: n/a
Default

You could probably set something up using data validation and set the limits
to the value that can be entered into a cell

"Springwalker" wrote:

Is there a way to set up cells so that only a certain amount of numbers can
be entered into that cell or group of cells? Similar to an Edit Mask in
Access.

  #3   Report Post  
Excel_Geek
 
Posts: n/a
Default


Sounds like "Data Validation" is what you're after.

Data -- Validation...


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=398389

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
Running Excel events even in edit mode.... Ishika Excel Discussion (Misc queries) 0 June 16th 05 06:53 PM
how do I create a data entry edit mask? Jeff Perreault Excel Discussion (Misc queries) 0 June 10th 05 09:16 PM
EDIT FORMULA BAR in excel 2003? why not? where is it? alnav89 Excel Worksheet Functions 2 April 26th 05 07:02 PM
Scan and edit document in excel 2003. johmoc Excel Discussion (Misc queries) 0 March 18th 05 04:53 PM
How to switch to edit the cell hon123456 Excel Discussion (Misc queries) 2 January 13th 05 10:40 AM


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

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

About Us

"It's about Microsoft Excel"