This content has been marked as final. Show 2 replies
I encountered this issue previously, but regarding leading zeroes. It was really a battle with Excel - not APEX.
Although I'd be interested to see if anyone has found a workaround that made Excel interpret it as a character instead of a number. We tried a few leads but to no avail.
We are using a work around. Open the file with notepad and edit the data. Format will be retained.