Format numeric field with leading zeros and sign 1

[ajv]

I would like to create a text file containing numeric fields with leading zeros and trailing sign. Any suggestions will be appreciated.

Thanks

ajv

 

[Hillary]

Format([your field name],"0000&quot&"+"

This will format all numbers to 4 places. Add or remove the 0's in the quote marks to format to more or less places. Don't forget the quotes! Ex. 1, 10, 100 and 1000 will be 0001, 0010, 0100 and 1000.

Replace the plus sign with whatever sign you want.

Hillary

 

[ajv]

Thanks. I tried this as follows:
num2: IIf([num1]>0,Format([num1],"0000000&quot & "+",Format([num1],"0000000&quot & "-&quot

However if num1 is -3 I get -00000003-. Works great with positive numbers.

Thanks.

 

[Hillary]

I'm assuming you don't want the first "-", you just want 0000003-.

What you have to do is take the absolute value of the number.

Try...
num2: IIf([num1]>0,Format([num1],"0000000&quot & "+",Format(Abs([num1]),"0000000&quot & "-&quot

Adding the Abs() around your [num1] will take the possitive value of the number but still allow the - at the end. I haven't tested this so I'm not sure if it will work.

Good luck!

Hillary

 

[ajv]

Works great!!. Thanks!!!

ajv