Hoping someone can illuminate me.
I have usernames that begin with one or more zero(s) for one of my EE tenants. When normal reports export as .csv, these leading zeros may be removed. If we manually export the data we can use .xls and that keeps the zero(s). If I format the username column as Text, this helps keep the leading zero(s).
The issue is when I go to upload these spreadsheets back into the LMS. When I convert the .xls to .csv, the zeros are removed, even if the column is formatted as text.
I was looking at the Automation App, and I think I’ll run into the same issue of needing a .csv file.
Any help is much appreciated!!
Best answer by BfarkasView original