Forum Discussion
E_Davis1908
Nov 27, 2019Copper Contributor
Excel Auto converts numbers to date format
We use Excel to generate our sample POs with our factory partners through our offices in Asia. This has been an ongoing issue and we're trying to determine the cause of it. Normally the format...
E_Davis1908
Nov 27, 2019Copper Contributor
I'll use that option as a last resort. Unfortunately my team in Asia needs the ability to change the QTY.
mathetes
Nov 28, 2019Gold Contributor
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."