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
=TEXT(Konstante!$B$5&Eingabe!$D2;"000000000000000000000000")
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:
000006030870067922200000
where I expected it to be
000006030870067922200305
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.