M
mcwilljg
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
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