Excel does not display entered values correctly
 

I am currently running Excel 2000 on WinXP Pro. Excel does not display the
correct values in cells when they are typed. The program arbitrarily assigns
a decimal value to whatever number is typed. For example, if "1111111111" is
entered, it is displayed as "11111.11111" I have gone through cell
formatting, detect and repair and other options, but none have worked. The
program use to work fine. It started this recently and it won't go away. If
it helps, when a number is typed in another program, i.e. notepad, and copied
and pasted into Excel the value displays fine. The problem lies in actually
typing values into Excel. This is a problem that I am unfamiliar with. Any
help is greatly appreciated.

Thank you,
John

Excel does not display entered values correctly
 

Try:

Tools/Options/Edit and check to see if "Fixed decimal places" is selected.
If it is then remove the check mark.

HTH
JG


"TSL1050" wrote:

I am currently running Excel 2000 on WinXP Pro. Excel does not display the
correct values in cells when they are typed. The program arbitrarily assigns
a decimal value to whatever number is typed. For example, if "1111111111" is
entered, it is displayed as "11111.11111" I have gone through cell
formatting, detect and repair and other options, but none have worked. The
program use to work fine. It started this recently and it won't go away. If
it helps, when a number is typed in another program, i.e. notepad, and copied
and pasted into Excel the value displays fine. The problem lies in actually
typing values into Excel. This is a problem that I am unfamiliar with. Any
help is greatly appreciated.

Thank you,
John

Excel does not display entered values correctly
 

That fixed it, thank you.

TSL1050

"pinmaster" wrote:

Try:

Tools/Options/Edit and check to see if "Fixed decimal places" is selected.
If it is then remove the check mark.

HTH
JG


"TSL1050" wrote:

I am currently running Excel 2000 on WinXP Pro. Excel does not display the
correct values in cells when they are typed. The program arbitrarily assigns
a decimal value to whatever number is typed. For example, if "1111111111" is
entered, it is displayed as "11111.11111" I have gone through cell
formatting, detect and repair and other options, but none have worked. The
program use to work fine. It started this recently and it won't go away. If
it helps, when a number is typed in another program, i.e. notepad, and copied
and pasted into Excel the value displays fine. The problem lies in actually
typing values into Excel. This is a problem that I am unfamiliar with. Any
help is greatly appreciated.

Thank you,
John