Handheld Barcode Scanner with Excel for iOS

Using Inateck BCST-50 handheld barcode scanner connected via bluetooth to IPad Pro for inventory and there is terrible inconsistency with the whole number being populated into excel on IOS. Have tested with the slowest speed setting from the scanner manual and still there is inconsistency with the numbers populating.

this is the scanner: chrome-extension://efaidnbmnnnibpcajpcglclefindmkaj/viewer.html?pdfurl=http%3A%2F%2Ffiles.inateck.com%2FBCST-50%2520manual-V23.pdf&clen=629062&chunk=true

also found on microsoft community: https://techcommunity.microsoft.com/t5/office-365/handheld-barcode-scanner-with-excel-for-ios/m-p/308664/highlight/false#M18766

any suggestions please on what to try would be much appreciated. thanks