7 Replies Latest reply: May 15, 2014 10:02 AM by KarenG _ RSS

    When a number isnt a number

    KarenG _

      Afternoon

       

       

      I have searched for days and days now how to solve my problem, but everything i find that i think may work.. doesnt.

      I have a report that i need to export, with the "centre number" as a number; this is a key field.  I have set it as "numeric", but when i open it in Excel 2003 there is an apostrophe (') in front of the number....

      i have tried VAL but it still exports as text....

       

      can someone please help (i have Monarch 8.02 Pro)

       

      Regards

       

      Karen