how do you reset the default settings and templates for Excel

T

Ted Deguzman

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?
 
A

Anne Troy

Tools-->Options, Edit tab. Uncheck "Fixed decimals". If that doesn't work,
check the regional settings in the control panel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working on birthday "book" for my wife and having layout/editing trouble 0
How Do I: Reset Excel 2007 back to Default Settings 1
How do I set the default format in a workbook to numeric? 1
How do you set Excel 2002 as the default program? 4
How can i reset a text box in PPT to its default settings 1
reset the nickname and automatic completion cache 1
How do I set default Excel Saveas file format to xlsx not xlsx 1
How can I reset the default pie chart label "Other" to "Equity"? 1

Top