I have a number 1234.56 for example, and I need the total length to be 18 characters with leading zeros. In other words, "000000000001234.56".
I currently have a formula that works by converting my number to a string using totext(), then calculating the number of leading zeros I need based of the result and then concatenating them to the front of the string. But I am thinking there is an easier way. Any insights appreciated.
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools:
I currently have a formula that works by converting my number to a string using totext(), then calculating the number of leading zeros I need based of the result and then concatenating them to the front of the string. But I am thinking there is an easier way. Any insights appreciated.
Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: