Yes, it's the formula. The library that we use is evaluating the formula result to be a numeric because it contains only 0-9. During import, this results in the leading zeroes being stripped.
I tried several formula tricks in Excel to force the evaluation to string. Ultimately, I had to include a non-numeric character. I used n "X" character.
- =TEXT(<Cell Name>,"X00000")
- Within a Project you can easily strip this leading character.
It's not perfect, but it should get you running.