New worksheet all cells with Date Format ???

[Chris72]

Hi,

Every time I open a new worksheet in Excel 2007 the cells are auto formated in Date format, whilst it is easy to correct the problem by selecting all cells and changing to General, all too often it's not until I've completed a handful of work that I remember that the Format is in Date.

I have checked all Advanced Options but no toggle for switching formats except when opening a new workbook.

Is there a solution to this?

Regards,

Chris...

 

[jo.stanley]

I am not that fimiliar with 2007 but I would suggest that 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.

 

[Mike Blackman]

Hi Chris,

If you go to the following address in your computer

C:\Documents and Settings\ "Your User Name" \Application Data\Microsoft\Excel\XLSTART[\code]

You should find an Excel template called Book.xlt, if you open this book it will be a blank excel just as you would get if you opened a new workbook (Identical Infact). If you format the cells back to General, or whatever suits you best, and save it to the same directory as Book.xlt then every workbook you open from there on in will be as you wish. 

You can make any setting changes you like and they will be replicated, from Gridlines = off in the options to formating to validation.

Set the workbook up exactly how you would like excel to open and save it down.

If there is no Book.xlt then just save it in the folder.

Once done, goto Tools/Options and the General Tab and enter the files path into the default File Location Box and close excel, when you reopen everything should be joyous.

Also Sheet.xlt works the same way but it is for any sheets you insert.

 

[Chris72]

Mikey and Jo,

Thank you it works perfect.

For users of 2007:

The extension is .xltx and the location is a little more labourious than Mikey pointed out:

> Microsoft Button > Prepare > Properties > Location Box

Thank you Mikey and Jo.

Chris....

 

[markmmix]

Thank you! I'd forgotten and remembered that there is an easy solution. Actually, Chris, Mike B's solution worked in Excel 2007 (using the .xlt extension) without the changes you provided. I will check out your method as well.

Mark / California