Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display fractions in a pull down list?
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 range Does that help? *********** Regards, Ron XL2002, WinXP-Pro "lmarti6" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
File Open doesn't display all directories (List vs Details) | Excel Discussion (Misc queries) | |||
Drop-Down List does not display choices | Excel Discussion (Misc queries) | |||
How select an item in a list box | Excel Worksheet Functions | |||
Creating a list from an existing list. | Excel Worksheet Functions |