Hi,

the answer is this formula: =substitute(A2,"0","")
but what about if you have like below:

00005006
00189000
fg000pl
noon0000

the above formula remove all zero's and for the above examples you will have:

00005006 = 56
00189000 = 189
fg000pl = fgpl
noon0000 = noon

does it work for you?

Thanks,
--
Farhad Hodjat


"ichihina" wrote:

how can I remove zero fills?

000089 -- 89
0076---76
00HWY---- HWY