Adding leading zeros to numbers

[Sondzin]

Greetings,

I used to know how to do this, but lost my notes on it and know it is
a simple solution.

I am numbering some tickets and the customer wants leading zeros to
show, you get 0001, 0002, 0012, 0013, etc.

I thought it was specifiying that the length of the variable was less
than X and then adding zeros in front of that, but I cannot remember.

An anyone tell me how to achieve this? My XL file is just 1 through
25000 with nothing else in the file.

Thanks,
David

[Bill]

There is an answer to your question in this old thread:

http://groups.google.com/group/xmpie-users/browse_thread/thread/ac8c65f7859bd4a2?hl=en_US#

BTW, if your Excel file has got only one single column, which contains
a simple sequential numbering (from 1 to N by steps of X), perhaps
would you prefer linking your application "to a Counter", rather than
"to a Data Source" in the uDirect palette?

[youston]

If you're using Excel, you can get the zeroes to display by typing a
single quote mark before them ... (ex: '001). This will turn the
column formatting to 'text', and your zeroes will display fine. No
need for any kind of formatting in uPlan.

Of course, if you're planning to do any calculating based on the value
of that field, this won't work for you.