View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Jane,

Go to ToolsOptions and on the Edit tab, check if the 'Fixed Decimal' option
is checked. If so, uncheck it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Janepige" wrote in message
...
I just started a new project where I work on a computer with Excel 97.
When I enter a number into a cell, e.g. the number 8 it turns it into

0,08.
Of course I've checked the format of the cells and they are all set to
standard. If I change it to "numbers" (or what ever it's called in the
english version) it still divides everythings I put into the cells with

100.
Can anyone help me with where this setting can be changed?
Thanks!