This just began happening: in either a new or old spreadsheet when I enter a
number it appears in the cell as a 1/100 decimal. A 1 will appears as .01,
200 appears as 2, 333 appears as 3.33. No matter how I try to reset the
format to number, general, etc. the same result occurs. Any suggestions?

Thanks.

Tools/Options...under the Edit tab uncheck "Fixed decimal"

Regards
Jean-Guy

"justonebid" wrote:

This just began happening: in either a new or old spreadsheet when I enter a
number it appears in the cell as a 1/100 decimal. A 1 will appears as .01,
200 appears as 2, 333 appears as 3.33. No matter how I try to reset the
format to number, general, etc. the same result occurs. Any suggestions?

Thanks.

Thanks!!! It worked. I'm still not sure why this began to happen, but glad
it stopped.

"pinmaster" wrote:

Tools/Options...under the Edit tab uncheck "Fixed decimal"

Regards
Jean-Guy

"justonebid" wrote:

This just began happening: in either a new or old spreadsheet when I enter a
number it appears in the cell as a 1/100 decimal. A 1 will appears as .01,
200 appears as 2, 333 appears as 3.33. No matter how I try to reset the
format to number, general, etc. the same result occurs. Any suggestions?

Thanks.