Excel Default Cell Format Problem
 

My numbers display as if they are all dived by 100; enter 555 display = 5.55.
How do I get back to a normal display?

Excel Default Cell Format Problem
 

Chuck, Your problem is related to Fixed Decimal formatting.

If you are using Excel 2007, then please refer this link to understand and
fix the problem:

http://office.microsoft.com/en-us/ex...4991033.aspx#3

If you are using Excel 2003, then please use the following steps:

[Tools] - [Options] - [Edit] tab. Turn off the [Fixed Decimals] option.

Hope this helps,
Kamlesh

"Chuck G" wrote in message
...
My numbers display as if they are all dived by 100; enter 555 display =
5.55.
How do I get back to a normal display?

Excel Default Cell Format Problem
 

Hi,

In 2003 choose Tools, Options, Edit and uncheck Fixed decimal

In 2007 choose Office Button, Excel Options, Advanced, and uncheck
Automatically insert a decimal point.

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

Cheers,
Shane Devenshire


"Chuck G" wrote:

My numbers display as if they are all dived by 100; enter 555 display = 5.55.
How do I get back to a normal display?

Excel Default Cell Format Problem
 

Kamlesh,
Excellent! It worked. Thanks for the help.

"Kamlesh Rao" wrote:

Chuck, Your problem is related to Fixed Decimal formatting.

If you are using Excel 2007, then please refer this link to understand and
fix the problem:

http://office.microsoft.com/en-us/ex...4991033.aspx#3

If you are using Excel 2003, then please use the following steps:

[Tools] - [Options] - [Edit] tab. Turn off the [Fixed Decimals] option.

Hope this helps,
Kamlesh

"Chuck G" wrote in message
...
My numbers display as if they are all dived by 100; enter 555 display =
5.55.
How do I get back to a normal display?

Excel Default Cell Format Problem
 

Thats great Chuck. Kindly park this post entry as "Answered", so that it
will benefit others too :)

Regards,
Kamlesh

"Chuck G" wrote:

Kamlesh,
Excellent! It worked. Thanks for the help.

"Kamlesh Rao" wrote:

Chuck, Your problem is related to Fixed Decimal formatting.

If you are using Excel 2007, then please refer this link to understand and
fix the problem:

http://office.microsoft.com/en-us/ex...4991033.aspx#3

If you are using Excel 2003, then please use the following steps:

[Tools] - [Options] - [Edit] tab. Turn off the [Fixed Decimals] option.

Hope this helps,
Kamlesh

"Chuck G" wrote in message
...
My numbers display as if they are all dived by 100; enter 555 display =
5.55.
How do I get back to a normal display?