9 Replies Latest reply on Jun 11, 2018 10:57 AM by TEnzin Dolma

    String value to INT conversion

    TEnzin Dolma

      HI all,

       

      I have a column where the data type is STRING. The values are represented as e.g. 10-15 hrs.

      How can I convert it to an INT so that I can perform calculation on it.I tried using INT(Column name) but the cell values changed to NULL,

      When I tried chagning the data type by right clicking and  change data type it again led to null values.