SQLUser formulated on Monday :
Is there a way of having the cell automatically have the 0000000# in
the Custom format when the spreadsheet is launched?
Not normally, but you could make a template (XLT) with the formatting
(along with whatever else) already set up how you want. Then just reuse
the template and do 'SaveAs' to store it as a XLS.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc