Convert code to text during export to excel

T222

I have a report which exports information of items such as crossreference no to excel. On report preview I have the information ok , such as Crossreference no 020000100 but on excel it gives 20000100 because it transfers them to number
Can someone help me how to export to excel this to text?
I have tried a lot of commands but it nothing seems to working.

Kishorm

you need 4 single quotes so something like this...

Bcode := '''' + CrossReference;

da_neal

Try to add ' before exported value. And one method to establish excel cell format to text.

T222

Yes i have tried to do this and add this to crossreference number but it doesn't accept my command
I have tried to put this in single code such as
Bcode := ' ' '

but doesn't accept it because program use single codes by itself. Is there any other way?

Kishorm

you need 4 single quotes so something like this...

Bcode := '''' + CrossReference;

T222

Thank you!!!!!!