default format for Excel numbers
 

Bringing up a new sheet and typin in the number 262 in any cell, gets entered
as 2.62; as if the entered nuymber is divided by 100. How do I change it back
to normal?

default format for Excel numbers
 

Goto the menu ToolsOptionsEdit tabuncheck Fixed decimal placesOK

--
Biff
Microsoft Excel MVP


"Chuck G" <Chuck wrote in message
...
Bringing up a new sheet and typin in the number 262 in any cell, gets
entered
as 2.62; as if the entered nuymber is divided by 100. How do I change it
back
to normal?

default format for Excel numbers
 

Tools Options Edit Clear the fixed decimal places checkbox

If this post helps click Yes
---------------
Jacob Skaria


"Chuck G" wrote:

Bringing up a new sheet and typin in the number 262 in any cell, gets entered
as 2.62; as if the entered nuymber is divided by 100. How do I change it back
to normal?

default format for Excel numbers
 

Hi,

In 2007 press Alt+1, choose Advanced, uncheck Automatically insert a decimal
point

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chuck G" wrote:

Bringing up a new sheet and typin in the number 262 in any cell, gets entered
as 2.62; as if the entered nuymber is divided by 100. How do I change it back
to normal?