I may be wrong, but I believe that the delimiter used by data validation
comes from Windows' Regional Settings and cannot be customized.

--

Vasant


"Rick De Marco" wrote in message
om...
Hi,

I have data validation set up on a cell which has my validation
criteria set to be a List. Everything is working fine for me except
when the data (coming from a database) I am creating the list from has
a comma, the list then treats it as a new entry even though its not.

Is there a different delimiter you can use in a validation list apart
from a comma? Are you able to specify it via code?

Cheers,

Rick