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

    Problem Importing from Excel

    fmpro_novice

      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!

        • 1. Re: Problem Importing from Excel
          philmodjunk

          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.)