valuing a labelled odds formula '15/8 I want result 1.875 ??????
Format the cell as ??/??
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Matthew" wrote in message
...
I need one cell to display 15/8 thus using the label.
But I also want to use the result of 15 divided by 8 based on the value
from
this cell.
I thought I could use the value and mid functions but it comes out in date
numbers.
The formula needs to apply to a range of odds....eg...100/30, 4/1, 8/13,
6/4
etc...
Please help !
|