ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How are symbols inserted in a data validation look-up list? (https://www.excelbanter.com/excel-worksheet-functions/109336-how-symbols-inserted-data-validation-look-up-list.html)

KJJL1

How are symbols inserted in a data validation look-up list?
 
I am using Excel2003. I have created a names range of cells that contain
symbols. I want to use data validation to force use of these symbols in other
cells. When used the data validation drop down list appears as Unicode
characters rather than the associated symbols although once a character is
selected the cell is actually filled with the associated symbol.
How can I get the symbols to appear in the drop down list rather than the
associated Unicode characters?


All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com