can i change the default cell format to text in a new document
 

i am dealing with product numbers that start with leading zeros. Excel by
default treats these as numbers, and leaves out the zeros.
Is there a way to set the default format in a new document to text, so that
excel will keep those zeros?
thanks
jay

can i change the default cell format to text in a new document
 

either format the cells as text or type ' before the number
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"jay" wrote:

i am dealing with product numbers that start with leading zeros. Excel by
default treats these as numbers, and leaves out the zeros.
Is there a way to set the default format in a new document to text, so that
excel will keep those zeros?
thanks
jay

can i change the default cell format to text in a new document
 

You can. Open a new workbook, set the cells format to Text, and then save
the workbook as a template file, named Book.xlt, in the XLSTART directory.
Each new workbook will be based upon that template.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"jay" wrote in message
...
i am dealing with product numbers that start with leading zeros. Excel by
default treats these as numbers, and leaves out the zeros.
Is there a way to set the default format in a new document to text, so
that
excel will keep those zeros?
thanks
jay

can i change the default cell format to text in a new document
 

You can also save a workbook with one sheet and Save As SHEET.XLT to same
folder.

This will become your default InsertWorksheet


Gord Dibben MS Excel MVP

On Thu, 8 Feb 2007 21:08:35 -0000, "Bob Phillips" wrote:

You can. Open a new workbook, set the cells format to Text, and then save
the workbook as a template file, named Book.xlt, in the XLSTART directory.
Each new workbook will be based upon that template.