I have an Excel worksheet that has three pages:
- "Eingaben" / Input - the user types in some data
- "Export" - the data is formatted and padded for PRN file Export
- "Konstante" - contains some constant values to be used in export tab
On page one there is a field that contains a number (formatting in input as "Standard"). The given number is "67922200305"
In Export the formula says
so the input value is supposed to be prefixed with "60308700" and the whole thing shall be zero-padded to the length of 24.
Strangely the output in Export is:
where I expected it to be
The format of the export field is Standard and the constant is Text.
To me it looks like "rounding" issue, though I guess '&' should concatenate the strings.