locked
Help creating a fixed width text representation of a number RRS feed

  • Question

  • I have created a calculation column with the expectation of getting values such as 20180523-00001

    =TEXT(Created,"yyyymmdd")&"-"&TEXT(ID,"#####")

    However, my strings are appearing as 20180523-1

    I also tried this:

    =TEXT(Created,"yyyymmdd")&"-"&TEXT(ID,"00000")

    However my strings all appeared as 20180523-00000

    (literally all with 5 zeros).

    So, how can I alter the calculation so that I get the expectation behavior of 20180523-00001?

    Thursday, May 24, 2018 1:38 PM