Try this:

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

or slightly shorter:

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

Hope this helps.

Pete

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?