I know that just putting a space or an apostrophe is the go-to but I have a dependent drop-down list and whenever I select +75 in the dropdown menu it makes a formula out of it, even though the source data has an apostrophe, is there any setting or some script that would block this?

the dropdown list


1 Answer 1


One way to do that is to use the Unicode SMALL PLUS SIGN instead of the regular + PLUS SIGN. They look almost the same, but the character does not get interpreted as the mathematical plus sign.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.