Stop Excel from converting integers into decimals (eg.; 12 to .12)
 

Recently Excel has started converting very number entered into that number
entered divided by 100. For example, every numerical entry n, becomes n/100.
This can be over-ridden if one enters "n.", thereby forcing the decimal.

This happens regard less of the format selected for number, currency,
percent, etc. It is some kind of global formatting that is defined in new as
well as old workbooks. It began a few weeks ago on both my home and my work
machine.

"Help" is no help. Surprise!

How does one shut this off? Help!!

Joe

Stop Excel from converting integers into decimals (eg.; 12 to .12)
 

Tools/Options/Edit, uncheck the Fixed Decimal Places checkbox

In article ,
mcwilljg wrote:

Recently Excel has started converting very number entered into that number
entered divided by 100. For example, every numerical entry n, becomes n/100.
This can be over-ridden if one enters "n.", thereby forcing the decimal.

This happens regard less of the format selected for number, currency,
percent, etc. It is some kind of global formatting that is defined in new as
well as old workbooks. It began a few weeks ago on both my home and my work
machine.

"Help" is no help. Surprise!

How does one shut this off? Help!!

Joe