Have to have a 6 digit number even if there is 5

[stann]

Hello

I have a situation where I have to send a 6 digit number to a company to be processed by email.

Some of the file may have only 4 or 5 digits it which case I would automatically like to add a zero before the number. Can this be done with a calc?

Thanks

STAN

[-Queue-]

Add an auto-enter calc: Right( "000000" & field ) and deselect 'Do not replace existing value for field'.

[Damocles]

-Queue- said:

Add an auto-enter calc: Right( "000000" & field ) and deselect 'Do not replace existing value for field'.

Right( "000000" & field,6 )

(I've been seeing this "zeroes" convention alot lately. Is the ",6" just implicit in the solution and I'm being redundant?)

Paul

[-Queue-]

No, that's just my typing too quickly. Thanks for the save!