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!