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