combobox fraction

[Spencer.Sadkin]

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

 

[Rick Rothstein \(MVP - VB\)]

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

Rick

 

[Spencer.Sadkin]

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

Rick

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