combobox fraction
 

I have a combobox populated with fractions that display properly.
After selection the fraction converts to a decimal, but the list
values are still fractions. How can i display the selected value as a
fraction?

Thanks

combobox fraction
 

Can you show/tell us how you populated the ComboBox with your fractions?

Rick

wrote in message
...
I have a combobox populated with fractions that display properly.
After selection the fraction converts to a decimal, but the list
values are still fractions. How can i display the selected value as a
fraction?

Thanks

combobox fraction
 

On Mar 12, 5:04 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
Can you show/tell us how you populated the ComboBox with your fractions?

Rick

wrote in message

...

I have a combobox populated with fractions that display properly.
After selection the fraction converts to a decimal, but the list
values are still fractions. How can i display the selected value as a
fraction?

Thanks

ya that was it, i figured it out yesterday. the populated values from
the cells were entered as 0 1/3 which shows in the formula bar as .
33333333 so it was already converted before being passed to the
routine... i fixed this by entering them as '1/3 and then converting
to a number in the routine

Thanks again