6 Replies Latest reply: Apr 21, 2014 8:59 AM by Ashfaq Mohammed RSS

    Text To Number

    Sindhu Neelisetty

      Hi,

       

      When my report is exported to excel, certain columns are in text format. I tried to change them to number format by using NUM function and Number Tab. After using both the things, this is not getting converted to number. I used following expression in my sheet object(Pivot table) .

       

      =num(Count ({ $ <[Deleted] = {'No'} > } DISTINCT [Key]))

       

      Kindly suggest me any ideas.

       

       

      Thanks,

      Sindhu.