Log In
Register
Home
May 2, 2014
Offline
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
July 16, 2010
Offline
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
May 2, 2014
Offline
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. 🙂
July 16, 2010
Offline
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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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
VIP
April 21, 2015
Offline
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.
1 Guest(s)
