rounded # to correct #

[Wagnerk]

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!

 

[Mike H]

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.

 

[Eduardo]

Hi,
Format the cells as general

 

[Bernard Liengme]

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

 

[David Biddulph]

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.