Click on Tools, Options, select Edit tab, untick fixed decimal, OK out
--
Hth

Kassie Kasselman


"Stargazer980" wrote:

I am using previously saved spread sheets in Excel. Any time I enter a number
I have to put .00 behind it to display the number correctly otherwise if I
type the year 2007 it ends up as (20.07).

I am taking all the setting back to default and would like to know how to
prevent this from happening again without defaulting everything again.