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 On Mon, Jun 8, 2009 at 4:15 PM, Blackburn, Melissa Chappars Ms. < [email protected]> wrote: > From the university Registrar’s system, I downloaded several thousand > student records into an Excel spreadsheet. The zip codes look fine in the > Excel spreadsheet although the initial zero does not show in the Formula > bar in Excel--the cells are formatted as zip code. > > From there I import them into an FMP 9 database where the zip codes lose > their initial zeros in FileMaker. Is there a way I can correct the Excel > sheet so I don’t have to manually insert the missing zeros in FileMaker? > > Thank you! > > - > * > Melissa Chappars Blackburn > *[email protected] > Miami University > Marketing Communications, 1130 UCM > 102 Glos Center > 513 529-7596 > 513 593-1664 cell > >
