Concatenate in 4 digit

  • Hi Everyone,


    I have an excel table (I joined the case) and I would like to sequence the value which is incremented in column C in 4 digits (d1, d2, d3, d4), I tried to use Functions like "Right" and "STXT" but it does not work, in contrary, it works for column A1 sequenced already in column H and column I.


    What to do, what is the appropriate solution, knowing that the values of the column C are incremented via a code VBA (should remains)

    Files

    • seyf1981.xlsm

      (24.34 kB, downloaded 48 times, last: )