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

First, try changing the format to General
select the range
format|cells|number tab

If that doesn't work, select an empty cell
edit|Copy
select the cells to fix
edit|paste special|add



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

--

Dave Peterson

There may be a few ways to get around this, but one I use is this -

In a cell next to the list of numbers you have use a formula that multplies
the number in your list by 1. This should turn it into a normal looking
number. (so if 0000001 is in A1, do this formula in B1, "=A1*1")

"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

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