Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
date format problem from opening dbf file in excel 2007 | Excel Discussion (Misc queries) | |||
conditionl format overrides explicit format | Excel Discussion (Misc queries) | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |