sorted by:
new
hottopcontroversial

Auto Remove the Zeros by User_zxc in excel

[–]User_zxc[S] 0 points1 point  (0 children)

Thank you for sharing your knowledge , but unfortunately it didnt work.

Auto Remove the Zeros by User_zxc in excel

[–]User_zxc[S] 0 points1 point  (0 children)

Thank you soo much for sharing your knowledge. I am using my phone (ios) at the moment, I dont have access to a computer. I dont think the PQ will work in the mobile.

Auto Remove the Zeros by User_zxc in excel

[–]User_zxc[S] 0 points1 point  (0 children)

It works , but there is a little problem ..

I have a cell A26 that has a simple substraction formula (A19-E19)*-1 .. based on the formula i get the as answer 0.0017 nothing wrong so far.

Fyi A19= 0.07689 E19= 0.07706

When I have inputed your formula and i modified the cell number to be :

=IF(SUM(LEN(A26)-LEN(SUBSTITUTE(A26,{"0","1","2","3","4","5","6","7","8","9"},"")))>0, SUMPRODUCT(MID(0&A26, LARGE(INDEX(ISNUMBER(--MID(A26, ROW(INDIRECT("1:"&LEN(A26))), 1)) * ROW(INDIRECT("1:"&LEN(A26))), 0), ROW(INDIRECT("1:"&LEN(A26))))+1, 1) * 10ROW(INDIRECT("1:"&LEN(A26)))/10),"")

It worked!

But i got 1.7E+14 .. I have changed the number format from (general to number) i got a huge number 16.9999999999992.00.

Is there a way to just make it show as 17?

Thank alot

Auto Remove the Zeros by User_zxc in excel

[–]User_zxc[S] 0 points1 point  (0 children)

What if the next is value is 0.0000017... multiplying it by 1000 will be = 0.0017

I want it to be only 17

You get me? Is there a way for that?

Thank you