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

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

Thanks for your reply Mr. Dibben,

Yes, multiple workbooks. Only certain columns but across several sheets in
that book.

There is existing code, but I don't know what to look for, what would change
the date? And it seems that the more columns changed to "general" the more
columns switch back to "date".

New workbooks are in the general format.

"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

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

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

Copying Styles between Workbooks


You can copy your styles to different workbooks ??


It is possible to copy styles between workbooks.


Open both the workbooks and activate the destination workbook. Select (Format Styles) and select the Merge button.


This dialog box will display a list of all open workbooks. Select the name of the workbook you want to copy the styles from and press OK.


Be aware that any styles with the same name will be overwritten. You will only receive a single prompt regardless of how many styles may be overwritten



Gord Dibben wrote:

In the problem workbook how are you inserting the new sheet?Macro or ??
04-Sep-09

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

wrote:

Previous Posts In This Thread:

On Tuesday, September 01, 2009 2:15 PM
Mary wrote:

Excel Format Problem - Date Overrides Format
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

On Tuesday, September 01, 2009 4:53 PM
Gord Dibben wrote:

Only one workbook and only certain columns in only one worksheet in thatbook?
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

wrote:

On Wednesday, September 02, 2009 8:16 AM
Mary wrote:

Thanks for your reply Mr. Dibben,Yes, multiple workbooks.
Thanks for your reply Mr. Dibben,

Yes, multiple workbooks. Only certain columns but across several sheets in
that book.

There is existing code, but I do not know what to look for, what would change
the date? And it seems that the more columns changed to "general" the more
columns switch back to "date".

New workbooks are in the general format.

"Gord Dibben" wrote:

On Friday, September 04, 2009 3:06 PM
Mary wrote:

Hi - "See any Book.xlt or Sheet.xlt in XLSTART folder"?
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:

On Friday, September 04, 2009 3:55 PM
Gord Dibben wrote:

In the problem workbook how are you inserting the new sheet?Macro or ??
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

wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Build a Selected Text Favorites Utility for your Web Site
http://www.eggheadcafe.com/tutorials...-text-fav.aspx