Zero
 

How can I alter the default setting in Excel 2003 to allows have "no zeros
shown"
--
flatwall
trying to live down retirement without falling off the edge!!

Zero
 

Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.

--
__________________________________
HTH

Bob

"flatwall" wrote in message
...
How can I alter the default setting in Excel 2003 to allows have "no zeros
shown"
--
flatwall
trying to live down retirement without falling off the edge!!

Zero
 

I tried this but got an error message that said the XLSTART folder was read
only and it wouldn't let me save anything to it. In it's properties, the
Read-Only check box says it applies only to files withing the folder. How do
I change the attribute to the folder itself?

"Bob Phillips" wrote:

Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.

--
__________________________________
HTH

Bob

"flatwall" wrote in message
...
How can I alter the default setting in Excel 2003 to allows have "no zeros
shown"
--
flatwall
trying to live down retirement without falling off the edge!!

Zero
 

Thanks Bob, Your solution sounds OK to me and I will try it. Thanks for
taking the time to respond, I appreciate it.
--
flatwall
trying to live down retirement without falling off the edge!!


"Bob Phillips" wrote:

Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.

--
__________________________________
HTH

Bob

"flatwall" wrote in message
...
How can I alter the default setting in Excel 2003 to allows have "no zeros
shown"
--
flatwall
trying to live down retirement without falling off the edge!!

Zero
 

BTW, if you want any added worksheets to also have that property, you need
to create a single sheet workbook with that option set and save that as
Sheet.XLT in the folder.

--
__________________________________
HTH

Bob

"flatwall" wrote in message
...
Thanks Bob, Your solution sounds OK to me and I will try it. Thanks for
taking the time to respond, I appreciate it.
--
flatwall
trying to live down retirement without falling off the edge!!


"Bob Phillips" wrote:

Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.

--
__________________________________
HTH

Bob

"flatwall" wrote in message
...
How can I alter the default setting in Excel 2003 to allows have "no
zeros
shown"
--
flatwall
trying to live down retirement without falling off the edge!!

Zero
 

cn't you right-click the folder and select Properties and change it there?

--
__________________________________
HTH

Bob

"Loris" wrote in message
...
I tried this but got an error message that said the XLSTART folder was read
only and it wouldn't let me save anything to it. In it's properties, the
Read-Only check box says it applies only to files withing the folder. How
do
I change the attribute to the folder itself?

"Bob Phillips" wrote:

Create a new workbook and set that option for each sheet, then save that
workbook as a template file called Book.XLT, and save it in the XLStart
directory.

--
__________________________________
HTH

Bob

"flatwall" wrote in message
...
How can I alter the default setting in Excel 2003 to allows have "no
zeros
shown"
--
flatwall
trying to live down retirement without falling off the edge!!