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

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

-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

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