2 Replies Latest reply: May 15, 2014 10:14 AM by Nigel Winton RSS

    External Lookups to Excel

    Jim Weeks

      Hello.

       

      I'm using Monarch Pro 10.5.  A number of my projects use lookups to Excel spreadsheets that were just created by previous projects.  What sometimes (fairly often) happens is that the data type being read in from Excel changes from Numeric to Character, even though the Excel column is numeric.  This causes the project to fail.  How can I get the data to be read in in a consistent format?  Or alternatively, is there an error trapping type formula that I could use to, no matter what type of data is being read in, it gets converted to numeric.

       

      Thanks in advance!

       

      Jim Weeks