remove preceding zeros

B

Bruce

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
 
C

CoRrRan

Bruce said:
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
 
R

Roseygains

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top