How to format programmatically

[Alain]

Hi to all,
I do not know if this is possible or not but I would like to know if it is
possible to programmatically format a number with leading zeros, I would
like to create an automatic numberring function everytime a user create a
new invoice,. instead of showing 1 I need to show 0001, that number will be
concatenated to another number that comes from a dropdown list (that part is
already under control)

After looking around, the only formatting function that I now is Format()
which is for date formatting, so is there a way to do this ??

Thanks for the advice

Alain

 

[Dan Artuso]

Hi,
Try this in the Immediate window (ctl-G)
?Format(1,"0000")
0001

 

[Alain]

Thanks again, exactly what I was looking for

Alain