Drop down list in Data Validation
 

Hello All
Please can you tell me if it is possible to get the "1/2" symbol into the
drop down list in Data Validation.


Thanking you in anticipation
--
Big Rick

Where you want the 1/2 symbol to appear, press the Alt key, and type
0189 on the number keypad.

This will be treated as text, not a number, if you're doing calculations.

Big Rick wrote:
Hello All
Please can you tell me if it is possible to get the "1/2" symbol into the
drop down list in Data Validation.


Thanking you in anticipation


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Sure you can!

Hold down the <Alt key, and enter
0189
Using the numbers from the num keypad,
*NOT* the numbers under the function keys.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Big Rick" wrote in message
...
Hello All
Please can you tell me if it is possible to get the "1/2" symbol into the
drop down list in Data Validation.


Thanking you in anticipation
--
Big Rick

Thanks a 1/2 million!
I was going wrong by not using the numeric keypad.
--
Big Rick


"RagDyeR" wrote:

Sure you can!

Hold down the <Alt key, and enter
0189
Using the numbers from the num keypad,
*NOT* the numbers under the function keys.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Big Rick" wrote in message
...
Hello All
Please can you tell me if it is possible to get the "1/2" symbol into the
drop down list in Data Validation.


Thanking you in anticipation
--
Big Rick