My problem is once I have completed an excel file, closed and return to same it has spontaneously formatted certain cells in the work book into date format – to solve this problem I have to highlight column, go to custom format & delete the weird date formats that have appeared at end of list. Sometimes it might not be a date format problem but an accounting format problem.
Any suggestions? Thanks
Hi Anne,
I've never heard of that before. Are these cells in an Excel Table or just regular cells? Do other people have access to this workbook? Does it happen with other workbooks?
Mynda
As far as I know they are regular cells. The user is a pretty experienced user and she is feeling frustrated by that. Let me check with her if it's one workbook or more..thanks. 🙂
Also see if you can replicate it on your PC or another PC. If you can't then it's something specific to her PC.
You can also try this:
Create a new excel workbook. When you open it for the first time, which is the default cell format displayed in Home tab, Numbers section? It should be General. If the default format is not General, then your default excel template was modified, you have to open that book.xlt file to customize excel defaults.
Here is a link where you can learn more: Customize-how-Excel-starts
I sometimes encounter problems like this when I use files from an older and/or (don't know if it's always and) other language version of Excel.
So maybe the other person uses a different language version?
Also look at Windows-Mac and that versions and conversion?
It shouldn't happen but sometimes it does.
I hope that the problem has been resolved. But I faced similar issue and finally found out a solution. If you require it please visit following link.
