Excel – How to reset Excel 2016 to default settings

microsoft excel

I changed some settings in Excel so that I treated percentages as decimals. it worked great for that one specific project, but now I can't remove this configuration, and all my columns across all projects past and current are having their values divided by hundred.

This is incredibly annoying, and is making Excel usable for me.
I've tried reinstalling it and deleting the REGEDIT values for Excel, but still it persists.

Can somebody please help me fix my Excel?

Best Answer

There is an option on the Advanced tab of Options in Excel to Automatically insert a decimal point. Advanced edition option to insert decimal

I haven't tested if this affects display of previously saved workbooks but it does seem to affect all new numeric entries in all workbooks after it is checked.

Related Question