Your are viewing a read-only archive of the old DiS boards. Please hit the Community button above to engage with the DiS !
does anyone know?
I actually do have an excell ting i have to have ready for tomorrow and Ive got a shed load of stuff to paste (from an sql queries) that have leading zeroes but no matter how I change the format of the cells to be text, they still keep removing the fucking leeding xeroes, whjy why why Itell it something and it blithely ignores wht im telling it if its text its fuvcking txt stop trying to predict ehat people want ...text means like verbatim doesnt it?
these are alphanumeric characters with forward slashed and hyphens sometimes and sometimes with leadinng xroes
do numeric characters to the appropriate length. I the other case do text numeric in the appropriate combination? It should work but if they're different character lengths it will take till 2037