View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lmarti6
 
Posts: n/a
Default How do I display fractions in a pull down list?

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?