AnsweredAssumed Answered

How to format a number to a three characters string

Question asked by f.falomir@ube.es on Sep 7, 2017
Latest reply on Sep 7, 2017 by f.falomir@ube.es

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...

Outcomes