I have a validated list that when it drops down is not in the format it needs to be. Eg I have 2 WingDings symbols that are on a "Data" worksheet and the list is defined and formatted in that font. On my working worksheet the cells that the dropdown list appear in are formatted to WingDings2, but when you click on the list arrow the dropdown list reveals the QWERTY symbol. eg [FONT="wingdings 2"]P[/FONT] shows as P.
How can I overcome this as when other users of the lists reveal the dropdown, they will have no idea what they need to select?
Any help much appreciated.