If you find that Excel is dividing your input by 100 for no apparent reason, it’s probably because you have checked “Fixed Decimal Places” under Tools>Options>Edit.
Uncheck that box to return to normal behavior. Of course it doesn’t have to be 100, it’s just that Excel defaults to 2 decimal places when that box is checked.
Hi,
These instructions were EXTREMELY HELPFUL.
How may I receive a dailydoseofexcel in my inbox? My e-mail address is Joyceephillips@verizon.net
THANK YOU VERY MUCH!!!