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

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

Rick

<(E-Mail Removed)> wrote in message
news:e71ba7b8-ed5b-4624-8818-(E-Mail Removed)...
>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

On Mar 12, 5:04 pm, "Rick Rothstein \(MVP - VB\)"
<rick.newsNO.S...@NO.SPAMverizon.net> wrote:
> Can you show/tell us how you populated the ComboBox with your fractions?
>
> Rick
>
> <Spencer.Sad...@gmail.com> wrote in message
>
> news:e71ba7b8-ed5b-4624-8818-(E-Mail Removed)...
>
> >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