4 Replies Latest reply on Jun 19, 2013 2:22 PM by Dan Carpenter

    Number formatting

    Dan Carpenter

      I am working with a text-based data download from a magazine. The revenue column is listed as:

       

      $23 million

      $19 million

      etc...

       

      Stupid I know, but how would I go through and change those text formats to numbers in millions? I tried custom formatting the field, but to no avail.