I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
use to get the real number which is 12.85? Please Help!

Hi,

I suspect this is a format issue, format the cell as general
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Wagnerk" wrote:

I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
use to get the real number which is 12.85? Please Help!

Hi,
Format the cells as general

"Wagnerk" wrote:

I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do I
use to get the real number which is 12.85? Please Help!

Suppose I have this:
A1 B1 C1
257 20 12.85 (C1 has =A1/B1)
I cannot see how formatting can give 12.00 - I can see how it could give 13
(with no decimals)
What formula are you using?
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Wagnerk" wrote in message
...
I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do
I
use to get the real number which is 12.85? Please Help!

I wonder whether you might have been using the QUOTIENT function instead of
dividing?
If you don't know what the QUOTIENT function does, look it up in Excel help.
If you want to divide A1 by A2, use the slant sign / to divide, so =A1/A2.
--
David Biddulph


"Wagnerk" wrote in message
...
I'm dividing two cell (257 by 20)---Excell inserts 12.00. What formula do
I
use to get the real number which is 12.85? Please Help!