I have run an export report from our operating system for a list of order
numbers, these numbers are 7 digits long. ie
0000001
0000010
0000029
0001000

How can I delete the prefixing zeros so it reads as follows
1
10
29
1000

Thanks