delete a prefix

[Guest]

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]

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

 

[Guest]

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")

 

[Guest]

Enter in an empty cell: 1, copy the cell.
Select the range, right-click > paste special > check "Multiply" > OK