Number format in cell changes
 

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.

Number format in cell changes
 

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.

Number format in cell changes
 

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.

Number format in cell changes
 

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.

Number format in cell changes
 

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.

Number format in cell changes
 

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.

Number format in cell changes
 

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.

Number format in cell changes
 

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.

Number format in cell changes
 

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.