Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days.
for removing trailing zeros and to retain leading zeros, I will write a small function that will achieve this.
for 2003 compatibility, I would need your support to test and get back to me, so that I can make it compatible.
Willing to take up your project. Thank you, Regards.