How can I display a number as a ratio of x:1 in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If yu want 16 displayed as 16:1 then select a cell and Pull-down
Format > Cells... > Number > Custom and in the entry field type:

00":1"
 
Many thanks.

Neil

Gary''s Student said:
If yu want 16 displayed as 16:1 then select a cell and Pull-down
Format > Cells... > Number > Custom and in the entry field type:

00":1"
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying ratio as number of times 2
Can Excel display the ratio of two numbers? 1
Ratios 4
Divide x/y should give Ratio x:y,How to express ratio in excel 2
Calculating ratios: Is there a formula that can do this? 2
Google Pixel 2 and Pixel 2 XL 2
Will VLOOKUP and MATCH work to find combinations of pulley diamete 3
ViewSonic VX2758A-2K-PRO-3 Gaming Monitor with 2K and 240Hz Unboxing 2

Back
Top