Removing 0 from number in specific scenarios

[NormChart55]

Hello,

I am having to add tweak some data for matching purposes elsewhere. I can easily remove the leading 1, but in the case of numbers that then have a 0 after them, I am unsure how to work this equation so that the 0 also gets removed in only those cases. Example below.

Store Number examples
Column D contains the stores in the format below
15563 = should be 5563 (already working)
12173 = should be 2173 (already working)
10449 = should be 449 (currently showing 0449)

IF(C8="DIRECT",RIGHT(D8,4)&" "&INDEX(LL!B:B,MATCH(Feed!D8,LL!A:A,0)),0)

 

[Fluff]

How about

IF(C8="DIRECT",RIGHT(D8,4)+0&" "&INDEX(LL!B:B,MATCH(Feed!D8,LL!A:A,0)),0)

 

[NormChart55]

How about

IF(C8="DIRECT",RIGHT(D8,4)+0&" "&INDEX(LL!B:B,MATCH(Feed!D8,LL!A:A,0)),0)

Works perfectly, thanks a bunch!

 

[Fluff]

You're welcome & thanks for the feedback.