Check symbol in drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-2354987%22%20slang%3D%22en-US%22%3ECheck%20symbol%20in%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354987%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20have%20the%20check%20and%20cross%20symbol%20appear%20in%20the%20drop%20down%20list.%20I%20have%20created%20two%20cells%2C%26nbsp%3B%20one%20with%20the%20check%20symbol%20(Wingdings%20font)%20and%20cross%20symbol%20(Wingdings%20font).%20When%20are%20create%20the%20drop%20down%20list%20the%20symbols%20appear%20as%20%22%C3%BC%22%20and%20%22%C3%BB%22.%20is%20there%20a%20way%20to%20have%20the%20list%20show%20the%20symbols%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2354987%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2355140%22%20slang%3D%22en-US%22%3ERe%3A%20Check%20symbol%20in%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053985%22%20target%3D%22_blank%22%3E%40jdinn76%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Data%20Validation%20drop%20down%20list%20uses%20a%20regular%20font.%20not%20Wingdings.%3C%2FP%3E%0A%3CP%3EThe%20check%20mark%20and%20cross%20symbol%20are%20not%20part%20of%20the%20font%20Excel%20uses.%3C%2FP%3E%0A%3CP%3EYou%20might%20use%20the%20square%20root%20symbol%20%E2%88%9A%20and%20the%20upper%20case%20X%20instead.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I want to have the check and cross symbol appear in the drop down list. I have created two cells,  one with the check symbol (Wingdings font) and cross symbol (Wingdings font). When are create the drop down list the symbols appear as "ü" and "û". is there a way to have the list show the symbols? 

1 Reply

@jdinn76 

The Data Validation drop down list uses a regular font. not Wingdings.

The check mark and cross symbol are not part of the font Excel uses.

You might use the square root symbol √ and the upper case X instead.