conversion ratio

[iceicebaby]

Im trying to take to cells and output it like this to another cell.

say if cell (A) has the number 100 and cell (B) has the number 5 I want
to divide a into b and have it output a conversion ratio...
Like below....HELP
I can get the number 20 but don't know how to add the 1: in front of
it.
1:20

 

[Dan E]

= "1:" & A1/B1

Dan E

 

[J.E. McGimpsey]

One way:

In your cell: =A1/B1

then Format/Cells/Number/Custom 1\:0

 

[justin]

-----Original Message-----
Im trying to take to cells and output it like this to another cell.

say if cell (A) has the number 100 and cell (B) has the number 5 I want
to divide a into b and have it output a conversion ratio...
Like below....HELP
I can get the number 20 but don't know how to add the 1: in front of
it.
1:20

use the CONCATENATE function
e.g. =CONCATENATE(1,":",A1/B1) or =CONCATENATE("1:",A1/B1)