Sequential Numbers Preceeded by Zeros

[NinaB]

I'm trying to add sequential numbers to a document. The numbers need to go from 0001 to 9999. I have the numbering all figured out but, I can't figure out how to make the zeros print without adding a decimal point. (Ex; 0001, 0002, 0003 etc.)

On the Mac I changed the field to format as decimal and set the fixed number of decimal digits to 3. Then I deleted the "." from the decimal separator box. Not very sophisitcated but this worked fine and just left a small space where the decimal would be but, when I view and print the same file on the PC a small square appears where the decimal should be!

Can ya help me out??

[-Queue-]

Change the field to text. You don't need a number field unless you'll be performing calculations on it, and even then you can easily convert it when necessary by using TextToNum(field). Then have it auto-enter serial numbers starting from 0001.

[NinaB]

Thanks for the reply... I DO need to do calculations on the numbers; each page of the document has nine numbers. I have a sequential number set on each page to advance by 9 as each new record is added. The individual numbers are set to calculate so that number1=pagenumber, number2=number1+1, number3=number2+1 etc.

My starting number is 0001. I have "number1=pagenumber" set to text and the number displays correctly; 0001. When I calculate number2=number1+1 and set the result to text the result is "2" and when I set the result to number the result is "2000"

Do I need to use the TextToNum or NumToText?

[-Queue-]

Use Right( "0000" & NumToText( numberX + 1 ), 4 )

[NinaB]

Fabulous!!!

Thank you for your help!