 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / June 2005Zero values
In excel 2002 how do I get into the default excel book template to uncheck the zero box and save it so that I dont have to go to options each time I open a new book. Look for a file called Book.xlt and change that.  SignatureHTH Bob Phillips > In excel 2002 how do I get into the default excel book template to uncheck > the zero box and save it so that I dont have to go to options each time I > open a new book. I can only find a file called Book1.xlt and that has the zero box unchecked. I am still getting new books with zero values. Where is Book.xlt? Also I cant rate postings as I cant find the message box to do so. Sorry > Look for a file called Book.xlt and change that. > > > In excel 2002 how do I get into the default excel book template to uncheck > > the zero box and save it so that I dont have to go to options each time I > > open a new book. If you find that book1.xlt in your XLStart folder, rename it to book.xlt. If that book1.xlt is not in XLStart, create a new workbook, change the settings you want and save it to your XLStart folder as book.xlt (not book1.xlt). > I can only find a file called Book1.xlt and that has the zero box unchecked. > I am still getting new books with zero values. Where is Book.xlt? Also I [quoted text clipped - 10 lines] > > > the zero box and save it so that I dont have to go to options each time I > > > open a new book. SignatureDave Peterson Brilliant, thanks > If you find that book1.xlt in your XLStart folder, rename it to book.xlt. > [quoted text clipped - 15 lines] > > > > the zero box and save it so that I dont have to go to options each time I > > > > open a new book.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.