LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
marie
 
Posts: n/a
Default Symbols in Data Validation List

Hi there,
I want to know if there is a way to show the symbols (e.g. webdings,
wingdings) from a drop down list instead of it showing the text counterpart?
For instance, I have a drop down list that shows arrows. When you click on
the cell where the data validation was set up, the drop down only shows the
text counterpart of those symbols and not the arrows per se.
I changed the format of the cell so it would show the symbol once selected
and it's working fine. What I need is for the actual symbols to show from the
drop down so as not to confuse whomever is going to use the worksheet.
Your assistance is greatly appreciated.

Marie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation list boxes Watson Excel Discussion (Misc queries) 4 May 26th 05 05:12 PM
Automatic Data Validation drop down creation Buddhapenguin Excel Discussion (Misc queries) 1 May 12th 05 08:41 PM
"Data Validation from list" Pocket excel ? graeme gw Excel Discussion (Misc queries) 0 February 22nd 05 10:31 PM
Refresh a Validation List? jhollin1138 Excel Discussion (Misc queries) 3 February 17th 05 05:48 PM
Data Validation Mike Excel Worksheet Functions 2 November 24th 04 04:51 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"