5 Replies Latest reply on Feb 29, 2016 8:48 AM by Stephen Lavery

    Formatting numbers with a delimiter "," using Custom Format

    Romil Shah

      Hi,

       

      I am trying to format number with a delimiter ",", but I am getting leading 0's even for a 3 digit number which is not required.

       

      As can be seen above, for 400 and 749 values leading 0's is not required.

       

      I used below custom format to represent above values and not Number, since I wanted to include symbols as well with the numbers to denote the trend (upward, downward or the same)

       

      Is there any way I can include Regular Expression or some code to truncate leading zeros for values having less than 4 digits.

       

      Regards,

      Romil Shah