Perhaps whoever created the spreadsheet applied a custom number format to it.

Does the same problem occur if you create a brand new spreadsheet?

Dave
--
Brevity is the soul of wit.


"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.