Hi I have a requirement where
A1 will become A001
A13 will become A013
Please suggest how to get this.
Regards,
changing format
Moderators: chulett, rschirm, roy
If you always have only one alphabet and followed by any number of digits then try this
Code: Select all
svAlpha=input_field[1,1]
svNum=input_field[2]
target_field=svAlpha : right('000':svNum,3)
You are the creator of your destiny - Swami Vivekananda
-
- Participant
- Posts: 101
- Joined: Mon Aug 13, 2007 2:32 am