remove preceding zeros

[Guest]

have a series of data with preceding zeros of variable length in column
A2:A1000
eg.

000301, 0000034456

In column B what formula can I use to remove the zero so the result is

301, 34456

Bruce

 

[CoRrRan]

have a series of data with preceding zeros of variable length in column
A2:A1000
eg.

000301, 0000034456

In column B what formula can I use to remove the zero so the result is

301, 34456

Bruce

=VALUE(A2)

(Make sure the formatting of column "B" is set to anything value
related, i.e. not "Text".)

CoRrRan

 

[Guest]

You can change it to number format.
Select your data, click on the information box on the top righ hand corner
and convert the number.
It automatically takes the zeros away.