how can I remove zero fills? 000089 --> 89 0076--->76 00HWY----> HWY
J JLatham Mar 13, 2007 #2 Sounds like you have a special format applied to the cells. Select the cells then Edit | Clear | Formats and see how they look.
Sounds like you have a special format applied to the cells. Select the cells then Edit | Clear | Formats and see how they look.
T Teethless mama Mar 14, 2007 #3 Select your range > Ctrl H > Find What: 0 > Replace With: leave blank > Replace All
F Farhad Mar 14, 2007 #4 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,
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,
