Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
mc mc is offline
external usenet poster
 
Posts: 5
Default Help required.....35 hours later :(

hi all
well
i want to create a drop down list and some of my selections have a "symbol"
but when i go use the drop down all i get is R or U anything BUT the symbol
what do i do to make it show the symbol
HELP
regards
mitch


  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,501
Default Help required.....35 hours later :(

Mitch,

I suspect that you didn't get an answer previously because your question
lacks clarity and I note you've asked it in exactly the same way as last
time. I certainly don't understand what you mean so perhaps you could
re-phrase and possibly provide examples of what your are trying to achieve.

Mike

"mc" wrote:

hi all
well
i want to create a drop down list and some of my selections have a "symbol"
but when i go use the drop down all i get is R or U anything BUT the symbol
what do i do to make it show the symbol
HELP
regards
mitch



  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
external usenet poster
 
Posts: 4,339
Default Help required.....35 hours later :(

If you are using Data Validation, you will need to format the DV cell with
font of the symbols e.g. Wingdings. HOWEVER, the symbols do not appear in the
drop down list BUT will appear correctly when selected.

So perhaps using symbols is not a good idea.

"Mike H" wrote:

Mitch,

I suspect that you didn't get an answer previously because your question
lacks clarity and I note you've asked it in exactly the same way as last
time. I certainly don't understand what you mean so perhaps you could
re-phrase and possibly provide examples of what your are trying to achieve.

Mike

"mc" wrote:

hi all
well
i want to create a drop down list and some of my selections have a "symbol"
but when i go use the drop down all i get is R or U anything BUT the symbol
what do i do to make it show the symbol
HELP
regards
mitch



  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers
mc mc is offline
external usenet poster
 
Posts: 2
Default Help required.....35 hours later :(

thanks for that
i am doing a production run sheet and using a "tick" or a "cross" would have
been a nice touch
thanks for the advice
regards
mitch



"Toppers" wrote in message
...
If you are using Data Validation, you will need to format the DV cell with
font of the symbols e.g. Wingdings. HOWEVER, the symbols do not appear in
the
drop down list BUT will appear correctly when selected.

So perhaps using symbols is not a good idea.

"Mike H" wrote:

Mitch,

I suspect that you didn't get an answer previously because your question
lacks clarity and I note you've asked it in exactly the same way as last
time. I certainly don't understand what you mean so perhaps you could
re-phrase and possibly provide examples of what your are trying to
achieve.

Mike

"mc" wrote:

hi all
well
i want to create a drop down list and some of my selections have a
"symbol"
but when i go use the drop down all i get is R or U anything BUT the
symbol
what do i do to make it show the symbol
HELP
regards
mitch





Reply
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
wages - multiply hours and minutes by number of hours worked Carol (Australia) Excel Discussion (Misc queries) 6 April 1st 07 02:16 AM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham Excel Discussion (Misc queries) 2 January 28th 07 09:40 PM
how to add hours and show actual hours not decimal numbers TWERNER New Users to Excel 2 August 21st 06 09:35 AM
Problem converting Hours to Days, Hours, Minutes Zyzzx Excel Worksheet Functions 4 October 24th 05 05:19 PM
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 03:56 PM


All times are GMT +1. The time now is 05:01 AM.

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"