EXCEL EXCEL ~~ Change the DATE format to TEXT format

We ran into problems when we are trying to upload data from Quadrate (Data Workbench) to SAP if there are columns that are showing the transaction date for each record, if we don't change the data type to TEXT, the upload will be failed.

I play and test a bit, summarize what I learned so far:

1. Add a comma sign in front of the date, however, it has a limitation, all the date must be the same in the column to take the max advantage of this skill

2. By using a TEXT formula, it can change the entire column but need an additional help column to paste the value back

3. By using the DATA function, TEXT to column