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.
I'll use that option as a last resort. Unfortunately my team in Asia needs the ability to change the QTY.
E_Davis1908 Part of the idea of Protection is that some cells are first "Unprotected", set to allow entry or modification; others protected. The whole idea being that you can collect info from others but they can't make unwanted (perhaps unintentional) changes. So it needn't be a "last resort."
