software

Every .xls file I open or create, this occurs. If I type in a number amp; hit
enter, that number divided by 1000 appears. This does not appear to be
related to formatting or a formula, but rather some global quot;setupquot; or
quot;optionsquot; feature in my desktop. In my office, no one else experiences this
amp; our IT guys have no answer for me.
I can get the number entered correctly by typing ie. 3.0 to get 3. But if I
type 3, I'll get .003 . If I double-click into a cell which contains 3, then
lt;entergt; I'll get .003 .
This could actually be useful at times... I would like to know how to turn
this ON amp; OFF.
Any idea?

Goto Toolsgt;Options and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

quot;Stuquot; gt; wrote in message
...
gt; Every .xls file I open or create, this occurs. If I type in a number amp;
hit
gt; enter, that number divided by 1000 appears. This does not appear to be
gt; related to formatting or a formula, but rather some global quot;setupquot; or
gt; quot;optionsquot; feature in my desktop. In my office, no one else experiences
this
gt; amp; our IT guys have no answer for me.
gt; I can get the number entered correctly by typing ie. 3.0 to get 3. But if
I
gt; type 3, I'll get .003 . If I double-click into a cell which contains 3,
then
gt; lt;entergt; I'll get .003 .
gt; This could actually be useful at times... I would like to know how to turn
gt; this ON amp; OFF.
gt; Any idea?
quot;Stuquot; gt; wrote in message
...
gt; Every .xls file I open or create, this occurs. If I type in a number amp;
gt; hit
gt; enter, that number divided by 1000 appears. This does not appear to be
gt; related to formatting or a formula, but rather some global quot;setupquot; or
gt; quot;optionsquot; feature in my desktop. In my office, no one else experiences
gt; this
gt; amp; our IT guys have no answer for me.
gt; I can get the number entered correctly by typing ie. 3.0 to get 3. But if
gt; I
gt; type 3, I'll get .003 . If I double-click into a cell which contains 3,
gt; then
gt; lt;entergt; I'll get .003 .
gt; This could actually be useful at times... I would like to know how to turn
gt; this ON amp; OFF.
gt; Any idea?

Tools/ Options/ Edit:
Unset quot;Fixed decimal placesquot;
--
David Biddulph