I need the Output to have 2 places in the result

[KSassone]

My output field needs to have an extra number inserted for 1 digit numbers - i.e. I need "01" to be reported instead of "1", e.g.:

Where I have the Data Preview showing "30E1"  I need it to show "30E01".  I tried the ,2 to indicate places, but it returned an error in the Preview.

Any direction, very much appreciated !

[Jonathan-Sherman · Accepted solution]

Hi @KSassone,

You could use the PADLEFT() function.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[KSassone]

Hi Jonathan,

Thank you - I entered as two formula lines on the formula tool - and while the Data Preview indicates the two places, the Output is still one place.

[Jonathan-Sherman · Accepted solution]

Hi @KSassone,

Can you replace the third line of your first formula with the formula you have in the bottom expression window? You will only need your top expression, however you need to change the third line.

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

[KSassone]

That worked !!  Thank you so much !!  I will accept this as a solution !

Thanks !!