View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] cyberlink.natalie@gmail.com is offline
external usenet poster
 
Posts: 1
Default Conversion Ratio

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?