Thanks Gord, I went to Fixed Decimal and it's already set at 300.

"Gord Dibben" wrote:

I can replicate this if I go to ToolsOptionsEditFixed Decimal
Places.........set to 300 which is max in 2003


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 07:40:01 -0700, Rubie
wrote:

Just recently, when typing a number in any cell of the spreadsheet the format
of the number typed changes. Example (3312 changes to 3.312E-297) when I
move to another cell.