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

    Formatting numbers with a delimiter "," using Custom Format

    Romil Shah



      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.



      Romil Shah