importing into numbered list
I really don't understand why my E2 Employee# numbered list is displaying the wrong code.
My source file (excel) when i download from the lesson is also not downloading the right.
i have the code in 1,5,8, but it should be in 001,005,008.
please can someone help. this is affecting my result every time i reference to this list
Thank you
Answers
-
I believe that excel changes your file when you open it due to some settings you have there. Excel reads code column as number instead of the text and automaticaly removes the zeros unnecessary for number format.
You can try to change settings (I honestly cannot help with that one) or simply make a formula in excel which will add the zeros. Something like this: MID(1000 + <Code>, 2, 3)
0 -
@KirillKuznetsov Thank You for your response. I downloaded the file again and didn't open it, imported to the list and it worked.
0 -
Here is a helpful article to related to leading zeros and .csv file types. This was something I too learned to hard way. 🙂 Glad you were able to redownload the file and successfully import.
1
