Gs1-128 Data Identifier 37 Dropping Decimal Point Follow
I'm trying to create a label using VBA from Excel, and my customer wishes to use the application identifier 37 (Number of units contained) to identify a weight held in tonnes, in a format #0.000. I'm passing the variable as a string in this format, but when it prints on the label, the decimal point is being removed, so, for example, a weight of 0.900 is displaying and scanning as 0900.
I've defined the field in Bartender as a Number with Precision set to Fixed at 3 decimal places (see the attachment) [attachment=1926:QuantityDefinition.PNG], and passing it in the following way:
btFormat.SetNamedSubStringValue "Quantity", Format(dblQuantity, "#0.000")
Can anyone offer any help as to what I am doing wrong?
Thanks and regards.