View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
CLR
 
Posts: n/a
Default Excel converts formula to number

If you type 10000/10 and press enter, the cell will display 10000/10.

If you type =10000/10 and press enter, Excel will see that as a formula and
the cell will display the result of the math.

hth
Vaya con Dios,
Chuck, CABGx3



"noyb" wrote:

How come when I enter 10000/10 excel displays 1000 in the formula bar
and not 10000/10? Does not always happen so I guess must be setting.
Thanks