SmartList drops leading zero for Bank Account number when exporting to Excel

(0) Share

Report

Posted on by Community Member

I used Smartlist Builder with the CM Checkbook Master table. The issue is when a bank account number has a leading zero the zero is dropped when exporting to excel. I tried creating a calculated field by selecting the Bank Account Number and setting the Field type to string. However the export to excel drops the leading zero from the bank account number. Short of creating a custom view do you have a solution does anyone have a solution ?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (2)

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

I believe if you go into Excel and format the column that the bank account will go to be of type Text before you hit the paste button will correct that.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

I received assistance from Nicole at EOne. The issue was setting  SmartlistEnhancedExcelExport=TRUE

change the setting to false resolves the issue

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

I forgot to mention that the setting is in the dex.ini file

Was this reply helpful? Yes No
aciccote 30 on at

Like (0)

Report

Doesn't changing this setting to FALSE make all of your amount fields default to 5 decimal positions?

Was this reply helpful? Yes No