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
Help required.....35 hours later :( mc Excel Discussion (Misc queries) 3 June 4th 07 11:17 AM
wages - multiply hours and minutes by number of hours worked Carol (Australia) Excel Discussion (Misc queries) 6 April 1st 07 01:16 AM
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham Excel Discussion (Misc queries) 2 January 28th 07 08:40 PM
Problem converting Hours to Days, Hours, Minutes Zyzzx Excel Worksheet Functions 4 October 24th 05 04:19 PM
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 02:56 PM


All times are GMT +1. The time now is 06:39 AM.

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

About Us

"It's about Microsoft Excel"