List separator other than comma

[pilot]

For data validation using a list, with the list entries being typed directly into the Source box, and each entry must include a comma as part of the entry, how should the text be entered so the comma is not viewed as a list separator? This is running on a network so I can't change the general Windows settings that control this.

 

[Damon Ostrander]

Hi pilot,

To enter a non-separator comma into a validation list, use a Unicode comma. You can enter a Unicode comma with the key sequence Alt-0130, where the 0130 MUST be typed on the numeric keypad.

 

[pilot]

I knew there would be a way, just didn't know it would be this simple. Thanks, Damon.