Number format in cell changes

[Rubie]

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.

 

[Sheeloo]

Choose Format Cells , select Number type for all cells you are having trouble
with.

 

[Gord Dibben]

I can replicate this if I go to Tools>Options>Edit>Fixed Decimal
Places.........set to 300 which is max in 2003


Gord Dibben MS Excel MVP

 

[Rubie]

Thanks for your reply Sheeloo. Tried that and the numbers changed to zeros.
All of the cells on the entire spreadsheet change the number. If I open a
new spreadsheet or a spreadsheet that was created before this one the number
also changes. Not sure if it's associated with the conditional formatting
that I put in for changing the color of a cell or if it's associated with the
import from a SQL database.

 

[Rubie]

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

 

[Bob I]

Yes, change it to Zero if thats what you want.

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

:

 

[Rubie]

That did it Bob!!! Thanks to all for your support.

 

[Gord Dibben]

You don't want it at 300.

Best to just uncheck "Fixed Decimals".


Gord

 

[Bob I]

Points to Gord for this observation.

That did it Bob!!! Thanks to all for your support.

: