Thanks for reply. I've checked ToolsOptions and don't have any
transitions checked. I have concluded that the behavior is related to
using a "+" or "=" when entering formulas. Using + at the beginning of
data entry results in the actual formula disappearing whereas using =
does not. I wonder why?


David McRitchie wrote:
I think you have managed to turn transition formula entry on in
Tools, Options, Transition(tab), Transition ....
turn off all transition items, they were place there so that
Lotus 1-2-3 spreadsheets or people using them work with Excel
like it was Lotus 1-2-3. Something that should not be used, as
things added to Excel later may be compromised, and you will not
be on same wavelength of others using Excel.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"noyb" wrote in message ...

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