DV dropdown boxes ignore formatting of the list range.

Your symbols will show up as plain text.


Gord Dibben MS Excel MVP


On Fri, 19 Feb 2010 07:51:02 -0800, Brooklyn
wrote:

I am attempting to create a drop down box in Excel, I have created a list in
a separate range but when I copy that range, it isn't the same in the Drop
Down box. Sounds like a formatting issue, but I can't seem to get the
correct symbols in my drop down box. help!