remove preceding zeros
 

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

remove preceding zeros
 

Bruce wrote:
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
-----------
Change NOSPAM to GMAIL

remove preceding zeros
 

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.

"Bruce" wrote:

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