Problem in a text display while exporting to Excel

poppins

Hi everyone,

I am trying to export some data to Excel...
I have a field named RIB of type text (length=20) which consists entirely in numbers, for example:
14904904100701827373.

The problem is that it is displayed in Excel this way: 1,49049E+19

What shall I do to make it display correctly???

postsaurav

Hi again,

You can use Format(FieldName) while sending data to excel. I think this should work.

Try it and let me know if it didnt worked.

postsaurav

Hi again,

sorry for the previous reply.

For formatting as text you need to specify @ while sendind data in excel.

ExcelBuf.AddColumn('14904904100701827373',FALSE,'',TRUE,FALSE,FALSE,'@');

poppins

Thanks a lot