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?

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?

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?

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?

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?