This is frustrating me! I want to create a data validation list where some of the entries contain a comma. So I do like this:
which gives me what I want, namely entries containing commas:
I save the file and everything is fine... until I reopen it again. Then I see this:
and when I go back and check in the data validation dialog I see that Excel 2007 has converted my commas to semicolons:
What on earth is going on? I searched the forums to find an answer, but without any luck. I don't know if this is also happening with Excel 2003?
which gives me what I want, namely entries containing commas:
I save the file and everything is fine... until I reopen it again. Then I see this:
and when I go back and check in the data validation dialog I see that Excel 2007 has converted my commas to semicolons:
What on earth is going on? I searched the forums to find an answer, but without any luck. I don't know if this is also happening with Excel 2003?