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?
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."