I think this will do what you want...

=A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)

The GCD (greatest common divisor) function requires the Analysis ToolPak add
in (Tools/Add-Ins from Excel's menu bar).

Rick


"Cin" wrote in message
...
I need to take information in 2 different cells, divide it, and show the
result as a ratio 2:1.
I know how to set the formula to divide the 2 cells, but the result is a
percentage, not in the format I need to see, which is 2:1.
Help?