2 Replies Latest reply on Dec 8, 2008 7:31 PM by ralvy

    Number formatting, et. al.

    ralvy

      Title

      Number formatting, et. al.

      Post

      I have a Number field that has values from 0001 to 9999. When I use the GetAsText function, the leading zeros are absent. E.g., 0001 is grabbed as 1. Browsing through the function list, I don't see a way to preserve those leading zeros when I use the GetAsText function.

       

      Also, a little related, is there a way to format a Number field so that those leading zeros are entered even if the user doesn't enter them? I imagine I'll have to do an AutoEnter calculation of some sort for this, testing for values under 10, those under 100, and then those under 1000. Just wondering if anyone already done this.