RD,

If you put the following in cell A1 (=1234567/123), is there a way to make
the display in cell b1 look like this (10037 R 16)

Is there a way to display the answer in 1 cell like 10037 R 16

"RagDyeR" wrote:

Gord,

Maybe he's referring to
=MOD(1234567,123)
Which returns 16
OR
=1234567/123
Which returns 10037.13008
Where he's interested in"13008".
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------



"Coffeecoco930" wrote in message
...
Hello Gord,

Thank you for the information. However, I am working with whole numbers,
not fractions. I will try for example with other math problems, though.

"Gord Dibben" wrote:

FormatCellsFractionsType "up to your choice"

e.g. set at "up to 3 digits"

1234567/123 = 10037 16/123

If something else needed please re-post or wait for one of the others to
suss
it out.

Gord Dibben Excel MVP

On Mon, 25 Oct 2004 15:59:03 -0700, "Coffeecoco930"
wrote:

I want to be able to display the quotient with the remainder number in
Excel.
Anyone have any idea how to do that?