Hello, I receive data from our geologist from a program that drops the
leading 0 from the API #'s for different wells. I need/have to restore this
0 in order to do imports into the software I use.
So I have a #: 11256094 that should read: 011256094
I have tried using the concatonate function sucessfully in excel (setting up
a '0 in one cell and the 11256094 in another cell), but when I save it as a
csv file, it drops the lead zero. I've reformatted my cells to text, but
this is still not helping solve this problem.
Any help will be appreciated.