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.

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

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

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.

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.

"Sheeloo" wrote:

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

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

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.

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

Rubie wrote:
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.

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

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

You don't want it at 300.

Best to just uncheck "Fixed Decimals".


Gord

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

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.

Points to Gord for this observation.

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

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