I have a huge column with single digits that my database batch loader requires there to be two digits in this field. I used a formula to append a leading zero but this just appends a ' (like '02) that makes the database auto loader barf all over itself.
So i tried to convert these "textnumbers' to just plain numbers but then it strips out the leading zero. Is it possible to do such a simple thing?
So i tried to convert these "textnumbers' to just plain numbers but then it strips out the leading zero. Is it possible to do such a simple thing?