Forum Discussion

DoDES's avatar
DoDES
Copper Contributor
Jan 13, 2021

Data validation

Hi, I don't know why when I separate my items by commas in my list, they dont appear as a list but they appear one after the other one the same line. So you can't select one of the other cause they are on the same line. I did put commas between and select list, so I don't understand what I'm doing wrong.

 

Thanks

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 13, 2021

    DoDES 

    Perhaps you shall use semicolon, not comma as list separator. It depends on your locale, more exactly list separator setting in OS for the locale.

Resources