Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Zero 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. |
#2
|
|||
|
|||
Look for a file called Book.xlt and change that.
-- HTH Bob Phillips "J.Reynolds" wrote in message ... 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. |
#3
|
|||
|
|||
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 "Bob Phillips" wrote: Look for a file called Book.xlt and change that. -- HTH Bob Phillips "J.Reynolds" wrote in message ... 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. |
#4
|
|||
|
|||
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). J.Reynolds wrote: 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 "Bob Phillips" wrote: Look for a file called Book.xlt and change that. -- HTH Bob Phillips "J.Reynolds" wrote in message ... 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. -- Dave Peterson |
#5
|
|||
|
|||
Brilliant, thanks
"Dave Peterson" wrote: 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). J.Reynolds wrote: 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 "Bob Phillips" wrote: Look for a file called Book.xlt and change that. -- HTH Bob Phillips "J.Reynolds" wrote in message ... 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
#N/A Values : Returned by Formulas vs Entered Manually | Charts and Charting in Excel | |||
Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |