If you define your field so that it auto-enters the padded value (in define fields, go to auto enter, calculated value and un-check the Œdo not replace¹, then filemaker will do it for you as you import from Excel. And the field is completely editable in the future, if a student changes their address.
Emma on 8/6/09 15:33, Miki Eff at [email protected] wrote: > Hi Melissa, > > Yes, first make sure that the field is specified as text. > > Then you can pad the "number" using a Replace command > > Padding would be like this: > > Right( "00000" & fieldName ; 5 ) > > Hope this is helpful, > Miki > > ----------------------------------------------------------------------------------------------------------------------------------------- Fourninety Limited, a member company of the Media Square plc group. Registered in England No. 3737606. Registered address Clarence Mill, Clarence Road, Bollington, Cheshire. SK10 5JZ Confidentiality Notice: The information in this document and any attachments are confidential. It is intended only for the use of the named recipient. If you are not the intended recipient please notify us immediately and delete this document. The contents on this document must not be disclosed to any other person nor may any copies be taken. The views of the author may not represent the views of the Company. Security Warning: This e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. All liability for any claims arising as a result of using this medium to transmit information by us or to us is excluded to the extent permitted by law. -----------------------------------------------------------------------------------------------------------------------------------------
