ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Are Input masks available in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/117945-input-masks-available-excel.html)

Ray with Group O

Are Input masks available in Excel?
 
I am trying to find a way to "force" users to enter a phone number in
999-999-9999 format. Limiting their entry to 12 characters as well. Is there
an easy way to do this?

Additionally, is it possible to make such a field required. Preventing a
user from saving the workbook unless this cell is completed?


All times are GMT +1. The time now is 05:27 AM.

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