AnsweredAssumed Answered

Number formatting, et. al.

Question asked by ralvy on Dec 8, 2008
Latest reply on Dec 8, 2008 by 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.

Outcomes