remove preceding zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

=VALUE(A2)

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

CoRrRan
 
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.
 
Back
Top