[brk2000]

I have a PC that has Office 2003. In Excel, it automatically takes the first 3 numbers entered into a cell and places them after the decimal point. For example:

I type: 123 --> Excel shows: .123
I type: 1234 --> Excel shows: 1.234
I type: 12345 --> Excel shows: 12.345

I have tried to changing the column to text and then back to numeric and that doesn't work.
I've tried creating a Special format and that doesn't work.
Others in the our company open the same excel file and have no trouble entering numeric data into the same worksheet.
I was told, although I did not try that excel.xlt or the default excel template file was copied to this machine and still the same results.

I would uninstall and reinstall, but I fear that with the new versions of software these days, I may not be able to reinstall again.

Thanks in advance for any help provided.

[Advertisements]

In excel
Tools / Options / Edit / Fixed Decimal Places can be enabled or disabled.

If enabled and set to 3 places, when you enter numbers without a decimal point you will experience the problems stated above.

Disabling the option above should resolve your problem.

HTH

[dsm]

In excel
Tools / Options / Edit / Fixed Decimal Places can be enabled or disabled.

If enabled and set to 3 places, when you enter numbers without a decimal point you will experience the problems stated above.

Disabling the option above should resolve your problem.

HTH

[brk2000]

dsm,

Thanks for the suggestion. It worked just great!

Have a good one.