Data validation - comma
 

Is there a way to have data validation NOT allow commas in a cell?

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?

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?

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?