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?