Enter in an empty cell: 1, copy the cell.
Select the range, right-click paste special check "Multiply" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"The Rook" wrote:
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