how to display more than 12 numbers in one single column of excel

[Former Member]

hi,

i lokesh, i am using gui_download for downloading excel sheet. actually during download one of my field contains 18 numbers, so in excel, in that particular column it shows as a 3.0000E18 and also for example: actually property number is 100000000000005263, it shows as a 1.0000E18, if i click on the 1.0000E+18, at the top it shows as a 10000000000000005000. it does not show last 3 numbers like 263.

what i want is during run time i want to display property number as a 100000000000005263 in one column.

any body knows for this solution pls let me know.

[Former Member]

Hi,

You're using gui_download to create a file which you then have to import into Excel? If so, then you can format the field as 'Text' during the import process. The default cell-category is 'General', which will treat numeric values as numbers, causing the problem you describe.

If you do not want to give users this task, then one idea is to put some non-numeric character(s) into the cell, e.g. 'PN 100000000000005263' - where PN stands for property number.

[Former Member]

thanks John MacNeill for your reply.

actually they dont want to display any character like PN before number.

[Former Member]

Hi lokesh,

Change the filetype to <b>DBF</b> in the FM and try out

[Former Member]

thanks chandrashekar, now that is working, thanks for u r help