Link to home
Start Free TrialLog in
Avatar of DAVID131
DAVID131

asked on

General format not applying in excel

Has anyone come across this issue with Excel (2007).
Across a number of workbooks Excel randomly resets some cells formats to Date (eg 01 January 1900) and although I reset the affected cells to the required format and save the changes, the date overwrite keeps occurring.
However this does not happen all the time and not always the same cells whilst an inconvenience the biggest impact is on drop down lists which are unusable until the master list if re-formatted
Any help would be appreciated
D
Avatar of Jorgen
Jorgen
Flag of Denmark image

Can you provide a spreadsheet to test?

It will be easier to look into your issue

Jørgen
Avatar of DAVID131
DAVID131

ASKER

Jorgen
This sheet is showing the date issue (highlighted in yellow) but given the volatility of the problem I can not guarantee that when you open the worksheet you will still see the same issues.
I forgot to mention that this problem occurs no matter what PC I may be working on
Thanks
David
Example-of-formats-being-re-set.xlsm
David
I have opened your spreadsheet, and can see the dates in the yellow column. I have reformatted the sheet with both the general format and the accounting format and saved the file reopened in both versions, and can not recreate the problem.

As far as I understand on your info, next time, this issue can be in another range.

Is this data imported or after you have keyed in the data yourself?

Jørgen
Jorgen
You are correct, next time the issue could be in another range or even a group of non contigous cells elsewhere in the sheet and although you have successfully reformatted this range this time even this range can revert to date format in the future after several openings of the worksheet.

The data is not imported I key it in and it is in the correct format at the time of keying.

This probelm started about 8 months ago when I working with a company who provided me with data downloads from their systems but some of the data's formatting was corrupt and had to be manually cleansed. But the present date issues are arising in newly created workbooks that have no links whatsoever to the corrupt files

Does that help ?

David
SOLUTION
Avatar of Faustulus
Faustulus
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
David,

I have just seen Faustulus response, and this gives good meaning. I am sure, that if you change your template that is opened, then your problem will be solved.

I can not explain how this was changed 8 month ago, but I am sure it was (maybe you saving in the opening work (XLstart or similar) folder.

regards

Jørgen
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks everyone for the team solution.
It seems that despite Microsofts increasing of the number of formats it will support in each new version of Excel, it is really down to designers/users to adopt a more minimalist approach to formatting in order to reduce the impact of this issue.