Excel Format Problem - Date Overrides Format


M

Mary

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
 
Ad

Advertisements

G

Gord Dibben

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
 
M

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.
 
M

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
 
G

Gord Dibben

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

Macro or ??

When you create a new blank workbook and go to Insert>Worksheet 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
 
Ad

Advertisements

Y

yaya su

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 Insert>Worksheet does tha
new sheet have the strange formatting

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

Delete it when you find it

Gor

wrote:

Previous Posts In This Thread:

Excel Format Problem - Date Overrides Format
Hi

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

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

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

Thanks
Mary

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 tha
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 t
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 MV

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 i
that book

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

New workbooks are in the general format

:

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 thes
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 dat
format for all cells. Still looking for a solution

Thanks for your help

Regards
Mar


:

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 Insert>Worksheet does tha
new sheet have the strange formatting

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

Delete it when you find it

Gor

wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
Build a Selected Text Favorites Utility for your Web Site
http://www.eggheadcafe.com/tutorial...c-86feb39cae83/build-a-selected-text-fav.aspx
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top