View Single Post
  #1   Report Post  
Neil
 
Posts: n/a
Default How can I display a number as a ratio of x:1 in Excel?

I want to display the result of a calculation as a ratio, i.e 16:1
Any ideas on how I can write a function that will allow this to display?