In excel format using < fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?ACCOUNT_NUM
In excel format using < fo:bidi-override direction="ltr" unicode-bidi="bidi-override"> <?ACCOUNT_NUMBER?></fo:bidi-override> increases the length of the field.
I have used the format shown above so that the account number gets displayed in the excel file correctly instead of the exponent format.
The length of this field is 16 numbers , however when I open the excel file and check the length of the field it shows it as 18.
The bank is not accepting this. When I open the excel file the length that is visible to me is only 16. However when I check the =LEN(field) it returns 18.
How can I resolve this issue.