Invoice(char column) with number 01 appears 1 in Excel
There is a custom report , it’s output type is XML
Everything is OK except that
I have a column in the report called “invoice or check number” it is a character column in the RDF file
The issue I have :
there is an invoice number 01 but it appears 1 not 01
Whereas in the XML source ,it appears 01
Also in the RTF file, it appears 01
When I generate Excel , it appears 1
Find attached files please , they illustrate what I explain
Could anyone guide me how to fix this issue ,please?
Thanks