1 Reply Latest reply on Nov 21, 2014 10:37 AM by philmodjunk

    Problem Importing from Excel

    fmpro_novice
    fmpro_novice Nov 21, 2014 10:00 AM

      Title

      Problem Importing from Excel

      Post

      I have a list of 7 digit numbers that are currently in an Excel file. When I import them into Filemaker, any number that has a 0 at the front, FM will drop the 0. So, 0975644 will import as 975644. I need the 0 in the front. Can someone tell me how to correct this?

      Thanks!

      • 40 Views
      • Tags:
        • 1. Re: Problem Importing from Excel
          philmodjunk
          philmodjunk Nov 21, 2014 10:37 AM (in response to fmpro_novice)

          Either import the data as text rather than a number into a text field or set up a calculation field (or text field with auto-enter calculation) to put back the leading zeroes.

          Right ( "0000000" & YourNumberFieldHere ; 7 )

          will put back all possible leading zeroes provided you have a calculation field with a text result type or a text field with this auto-enter calculation. (Be sure to enable auto-enter options during the import.)