Number format in cell changes

R

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

Sheeloo

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

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
 
R

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