Hi,

In cell C1 I entered a comma, highlight the range you want to apply the
validation to and then In the data validation choose Custom and enter

=ISERROR(FIND($C$1,A1))

where A1 is the first cell of the data validation range.

--
Cheers,
Shane Devenshire


"mns" wrote:

Hi,
I want to make a rule for a sheet which gives an alert when a user enters
"," comma in the cell while typing 12,34. I tried Data Varification part
couldnt figure out how to make this happen. If anyone knows how to restrict
spesific character I would be happy to hear it.

Thanx