ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Edit Mask (https://www.excelbanter.com/excel-discussion-misc-queries/41904-edit-mask.html)

Springwalker

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.

bigwheel

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.


Excel_Geek


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



All times are GMT +1. The time now is 12:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com