Graphics

 View Only

  • 1.  Add a Comma

    Posted 07-03-2018 17:50
    I am reading numbers from a Excel spreadsheet with Datalinq. I have tried to format the Excel to add the comma, but Xpression is not show it. How do I add a comma to the numbers?
    I tried a script text = FormatNumber (Text) but it ends up with a .00 and I dont need that. I'm just trying to get a number count.
    Thanks


  • 2.  RE: Add a Comma

    Posted 07-03-2018 19:16
    Try
    text=FormatNumber(Text, 0)
    #XPression


  • 3.  RE: Add a Comma

    Posted 07-03-2018 19:31
    That's it. Must be some Excel problem. Many thanks !!!!!
    #XPression