In the problem workbook how are you inserting the new sheet?

Macro or ??

When you create a new blank workbook and go to InsertWorksheet does that
new sheet have the strange formatting?

If so then I would suggest you have a SHEET.xlt Template in your XLSTART
folder.

Delete it when you find it.


Gord

On Fri, 4 Sep 2009 12:06:01 -0700, Mary
wrote:

Hi -

"See any Book.xlt or Sheet.xlt in XLSTART folder"? (I cannot find these
files). ?Help? What do i do with them once i find them?

To clairfy: new workbooks are fine - all cells default to general format.

However, any "new" sheet within the "problem workbook" defaults to date
format for all cells. Still looking for a solution?

Thanks for your help.

Regards,
Mary




"Gord Dibben" wrote:

Only one workbook and only certain columns in only one worksheet in that
book?

Do you have any code running that would change the formatting?

Or all new workbooks and sheets?

Default new workbooks and worksheets should already be default set to
General format for all cells.

Your default new workbook and worksheet may have been altered.

See any Book.xlt or Sheet.xlt in XLSTART folder?


Gord Dibben MS Excel MVP

On Tue, 1 Sep 2009 11:15:06 -0700, Mary
wrote:

Hi,

Hope someone can help! Everytime I open this file, certain columns format
is overwritten with the date.

I change the format back to text or general or number or accounting or
custom. And the next time I open the file, it goes back to Date. Even
protected worksheets have the numbers over written with the date. Any new
workbook has all the cells formatted as date.

How can I get rid of this date override and get excel to A) keep the formats
I set and B) default blank worksheets to number format.

Thanks,
Mary