I want change the numbers, 1 ~ 9 to 01 ~ 09 in column

[#1]

Hello,

I have two column, Lot and wafer as shown below.

How can I make wafer_rev column, where the single digit values (1~9) are changed to double digits (ex, 01, 02, ,,,,09. No change in 11~20)

Is there a simple script for this ?

Please advise me.

Lot	wafer	Wafer_rev
DA1	1	01
FA2	3	03
UJ3	11	11
DS2	9	03

Thank you in advance

[#2]

If what you are attempting to do, is to get your data to order correctly, the easiest thing to do, is to just change the Data Type of the wafer column to numeric.

But if you need it for other reasons, a simple formula to use for the Water_rev column is:

Substr( "0", Length( :Wafer ) ) || :Wafer