Morovia Community

[pohboonsiang]

I was trying to convert the below string to code128 barcode with human readable text. I used excel function code128ex but could not find the appropriate font type to display both barcode and readable text. The input string contains carriage return (~d013) and pipe ("|").

Input text: |338015391501~d013110110003764011~d0131010~d013088000
If use font MRV Code128M, it will only show me the barcode without text.
If use font MRV Code128cMa, it will show me the barcode with text "9299338015391501 77179910110003764011 77991010 779908800005" instead of "|338015391501 110110003764011 1010 088000".

Please help. Thanks.

[glitch]

When you are doing mixed Code128 character set, you can't get the human readable displayed correctly using the font, because the font can't alter its characters dynamically. You will get the correct result from the barcode.

To work around the problem, you can use the cell below for human readable text.

Or you can use Barcode ActiveX control (http://www.morovia.com/activex/barcode-lite.asp), which fits better in your scenario.

[pohboonsiang]

Thanks for the replies. I will use cell below to display human readable text.