title: How do I display a ratio in Excel in the format A:B?
body: <p>I have an Excel spreadsheet of data like:</p>
  
  <pre><code>ColumnA ColumnB
  33        11
  25        5
  6         4
  </code></pre>
  
  <p>What i would like to do is add a third column which shows the ratio of columnA to columnB in the format of A:B. For example:</p>
  
  <pre><code>ColumnA ColumnB   Ratio
  33        11       3:1
  25        5    5:1
  6         4    3:2
  </code></pre>
  
  <p>Does anyone know of a way to achieve this?</p>
  
  <p>Thanks in advance.</p>