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!!