software

I am trying to create a pull down list that contains a list of fractions.
Typing it as follows:
1/8,1/6,1/4
in the Data Validation Source field results in my fractions being converted
to dates.
If I type it like:
'1/8,1/6,1/4'
my list looks like this:
'1/8
1/6
1/4'
I do have the cell formated to be a fraction, but this doesn't seem to help.
Any suggestions?

Try something like this as your list:

0 1/8,0 1/6,0 1/4

or
put your list in a range of cells and refer to that rangeDoes that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;lmarti6quot; wrote:

gt; I am trying to create a pull down list that contains a list of fractions.
gt; Typing it as follows:
gt; 1/8,1/6,1/4
gt; in the Data Validation Source field results in my fractions being converted
gt; to dates.
gt; If I type it like:
gt; '1/8,1/6,1/4'
gt; my list looks like this:
gt; '1/8
gt; 1/6
gt; 1/4'
gt; I do have the cell formated to be a fraction, but this doesn't seem to help.
gt; Any suggestions?