Ah. You're absolutely right. I made the opposite assumption from you,
and there's no good reason for it.
If the OP wants integral divisors, and doesn't mind the result being
Text rather than a number (probably a good assumption):
=SUBSTITUTE(TEXT(A1/A2,"0/0"),"/",":")
(I don't know if that's been suggested already - didn't see it in *this*
thread).
In article ,
"Rick Rothstein \(MVP -
VB\)"
wrote:
So the question is whether the OP wants the ratio to always be
against ':1' or not. Unfortunately, she did not give an example by
which we could decide.