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

N

Neil

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?
 
G

Gary''s Student

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"
 
N

Neil

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...
 
Top