View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mary Mary is offline
external usenet poster
 
Posts: 190
Default 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