Forum Discussion
Excel Auto converts numbers to date format
I'm not at all sure how anyone here on the boards could determine cause for you.... Indeed it's possible that somebody has their Excel set to default to date format...
What I wonder, short of determining cause, is whether it can be prevented by using Protection, applied to the workbook/worksheet in all cells except those where data entry is desired. Is such a thing possible in your environment?
mathetes I may have stumbled onto the source. There were several Custom Styles that were showing on the spreadsheet. I'm not sure of the origin, but they were labeled Normal_xxxxx (xxxx being various other names). All were set to Date format. The normal "Normal" had also been changed. Opening up a fresh new spreadsheet this is in "General" format. Could be that these were a template that's been used for the past 9 years... something my predecessor created.