Help in excel

  • Thread starter Thread starter Jay Kathir
  • Start date Start date
J

Jay Kathir

Hi,

I have recently installed Office Systems 2003 and started
working on MS Excel 2003. I found it strange when I type a
number in any cell in a worksheet, the number is devided
by '10'. So when I type 20 and move to the next cell, it
automatically appears as 2. Any help would be appreciated.

regards
Jay
 
Jay,

Menu Tools>Options and go to the Edit tab. See if the Fixed Decimal box is
checked, if so uncheck.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
GO TO TOOLS/OPTIONS/EDIT/FIXED DECIMAL = IS IT EQUAL TO 1?
MAY WANT TO TURN OFF OPTION, OT TYPE IN A DECIMAL AFTER
EACH NUMBER YOU TYPE IN...
 
Back
Top