ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   how do you reset the default settings and templates for Excel (https://www.excelbanter.com/setting-up-configuration-excel/116476-how-do-you-reset-default-settings-templates-excel.html)

Ted Deguzman

how do you reset the default settings and templates for Excel
 
I have a new user taking over a new position and when she opens her excel and
types in a value with out any decimals.(ex; 111) and the following appears in
the cell: (1.11E-08). and then gives a value of 0.0000000111. Any suggestions
on how to reset to default book or template?


Anne Troy

how do you reset the default settings and templates for Excel
 
Tools--Options, Edit tab. Uncheck "Fixed decimals". If that doesn't work,
check the regional settings in the control panel.
--
~Anne Troy
www.OfficeArticles.com


"Ted Deguzman" wrote:

I have a new user taking over a new position and when she opens her excel and
types in a value with out any decimals.(ex; 111) and the following appears in
the cell: (1.11E-08). and then gives a value of 0.0000000111. Any suggestions
on how to reset to default book or template?



All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com