If I type in 3, I get .003 after hitting enter. All .xls files.

Giganews Newsgroups
Subject: If I type in 3, I get .003 after hitting enter. All .xls files.
Posted by:  Stu
Date: Wed, 10 May 2006

Every .xls file I open or create, this occurs.  If I type in a number & hit
enter, that number divided by 1000 appears.  This does not appear to be
related to formatting or a formula, but rather some global "setup" or
"options" feature in my desktop.  In my office, no one else experiences this
& 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
<enter> I'll get .003 .
This could actually be useful at times... I would like to know how to turn
this ON & OFF.
Any idea?

Replies