in

InaPlex Forums

Forums and downloads for InaPlex customers and partners.

Importing percent sign

Last post 03-17-2010 21:12 by admin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-17-2010 20:54

    • amycgm
    • Top 10 Contributor
    • Joined on 04-27-2009
    • Posts 7

    Importing percent sign

    We are using Inaport 7.1 with Goldmine 8.5.2.9. We are importing information from a spreadsheet into _details. The detail is set up with the the percentage we are trying to import in the zip field. We would like to include the percent sign (%). How can this be done? Thank you.

  • 03-17-2010 21:12 In reply to

    Re: Importing percent sign

    Hi

    The data is probably coming out of Excel as a number.

    Try using the ntos() function to convert it from a number to a string in the correct format:

    ntos(#myField, "00%")

    Regards

    Admin

Page 1 of 1 (2 items)
InaPlex Limited 2011