Need help to edit formulas

[RAJESH1960]

Hello formula experts
I have this data in this workbook which is working 90% correct When I run the code button Except for one problem. In the 2A Extract sheet, The Invoice numbers with text are displaying the correct results in columns H to AG. If the Invoice number is a number, then the formulas in columns H to AG are displaying 0 in the whole row. I need your help to edit the formulas from columns H to AG to get 100% correct result.
To check if the formula is working check the round off column H in 2A Extract sheet. It should not be more or less than +2 / -2.

formula to correct.xlsm

 

[RAJESH1960]

Shared the issue.
Excel Ask & Answer | Facebook

 

[Anthony47]

The problem seem to be with the Invoices numbers that are purely numeric, eg 59

Which is the sheet that shows the initial data? I'd like to check whether they are numeric from the beginning or they starts as strings and then some of the macro make them numeric

 

[RAJESH1960]

Thanks for responding Anthony47. The issue is solved just now in the other forum.

 

[RAJESH1960]

The problem seem to be with the Invoices numbers that are purely numeric, eg 59

Which is the sheet that shows the initial data? I'd like to check whether they are numeric from the beginning or they starts as strings and then some of the macro make them numeric

At first even I thought that the initial data (B2B) were showing numbers with errors could be the problem. But the 2A is extracted from B2Bcorrectly without any errors. The final 2A extract data is derived from the 2A sheet which doesn't have any errors. Hence, there was no issue in the invoice numbers. The issue was in the formula which is corrected now.