Hi capreecorn,

Supposing you have the data in Cell A1, use following formula:-
=VALUE(A1)
It will eliminate the starting zeros. Thanks.

--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"capreecorn" wrote:

How can i delete zero in start of value by using formula i.e (0000010 in to 10)