| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data validation - comma
Is there a way to have data validation NOT allow commas in a cell?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data validation - comma
Select the cell you want to validate
Select Data - Validation - Custom Add this formula =IF(ISERROR(FIND(",",A5)), TRUE, FALSE) This is for Cell A5 but you can use it for whatever cell you just selected... HTH "Steph" wrote: Is there a way to have data validation NOT allow commas in a cell? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data validation - comma
Steph,
Do you mean DataValidation, or just checking input? -- HTH RP (remove nothere from the email address if mailing direct) "Steph" wrote in message ... Is there a way to have data validation NOT allow commas in a cell? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data validation - comma
Thank you!!
"Jim Thomlinson" wrote in message ... Select the cell you want to validate Select Data - Validation - Custom Add this formula =IF(ISERROR(FIND(",",A5)), TRUE, FALSE) This is for Cell A5 but you can use it for whatever cell you just selected... HTH "Steph" wrote: Is there a way to have data validation NOT allow commas in a cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| How do I add an item with comma in the list of data validation | Excel Discussion (Misc queries) | |||
| Data Validation - Allow numbers, comma, - and space | Excel Discussion (Misc queries) | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| Show comma in data validation list? | Excel Discussion (Misc queries) | |||
![Steph[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
