remove zeroes

[Iamsuyog]

Dear all

i want to remove the starting zeroes


source
000046
000001
000123
005426
012345
876541

output must be

46
1
123
5426
12345
876451

could you please provide the formula?

 

[Sanjeev1976]

Dear all

i want to remove the starting zeroes


source
000046
000001
000123
005426
012345
876541

output must be

46
1
123
5426
12345
876451

could you please provide the formula?

You can use the value formula and it will remove the beginning zeros. If you want to reconvert it to text, you can use the text formula i.e. text(value(Cell_Reference)) or just value(Cell_Reference)

 

[Special-K99]

With data in column A

in B1
=A1+0
and copy down the column
Output is in column B

 

[SyedUsman]

Dear all

i want to remove the starting zeroes


source
000046
000001
000123
005426
012345
876541

output must be

46
1
123
5426
12345
876451

could you please provide the formula?

Data > Text To column > Finish