AnsweredAssumed Answered

How to format a number to a three characters string

Question asked by on Sep 7, 2017
Latest reply on Sep 7, 2017 by

Dear all:


I have a number between 0 and 999, and I would like to format it as follow:

If <10:                         00X

If >=10 and <100:       0XX

If >99:                         XXX

it means, to have a three characters string to allow to be sort properly...


I don't know if using regular expression I can do it...


Thank you very much in advance...