[RESOLVED] Barcode Issue?
Hi everyone. I have a barcode scan thing. Anyway, my question is how can we remove or add the zero's in a barcode. In my case I have barcode read two different way as:
1- 1234
2- 001234
---> all I need is the "01234"
Can anyone help me how to omit the zero or add it if when barcode read that way?... please any advice would be appreciated.
Re: [RESOLVED] Barcode Issue?
Another option that could be done with just one line would be to add 0s at the begining then take the right 5 characters
Code:
MyStr=Right$("00000" & BarcodeValue,5)