Percentage changes to number in my multiple selection dropdown list when selected first.

Hello,

I've copied the code for a multiple selection dropdown list - so now i am able to select more than 1 entry which is separated by commas. My problem, is that one of the values in my list is 100%. When I go the cell to select my items from the dropdown list, I want to be able to select 100% as the first entry. When I do so, it shows up perfectly as I want to see it as 100%, however...when I select the second entry, it changes it to "1". I have played with custom formattting, changing it from percentage to general to text to number - nothing works! Any help would be most appreciated! thank you.

Hi Winon, I tried it on the same sheeet but it still is converting 100% to 1 after I select the second item.

hello
give us the code

Hi Thank you for your reply, however it is still not working. When I select 100% it shows up there fine, but when I select the second entry, it changes the 100% to 1.

Here is the code:

Please Login or Register  to view this content.

Thank you Winon! It worked!

Format the B14 as Text. I think your code will work fine then.