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

[Guest]

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

 

[Guest]

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)

 

[Bob Phillips]

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)

 

[Gord Dibben]

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

This will become your default Insert>Worksheet


Gord Dibben MS Excel MVP