Hello, Pete_UK!
You wrote on 27 Sep 2006 16:42:59 -0700:

PU =CONCATENATE(1,":",ROUND(A1/B1,0))

PU or slightly shorter:

PU ="1:"&ROUND(A1/B1,0)

PU Hope this helps.

PU Pete

PU wrote:
?? I used the ffollowing to get the conversion ratio format I
?? wanted CONCATENATE(1,":",A1/B1)
??
?? Now I am trying to figure out if there is a way to show
?? the results in a whole number ie 1:32 instead of
?? 1:32.6666666.
??
?? Is there a way to do that?

To tell the truth, I'm not quite sure what you want but if you
have a decimal number, you could investigate formatting to a
fraction. Format cells Fraction

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not