2 Replies Latest reply: May 15, 2014 9:58 AM by Pat Donnelly RSS

    Values shifting in cells when exporting to Excel

    Pat Donnelly

      Why are the values shifting when I export to excel.  If I cut and paste from the table view to Excel it doesn't happen?

       

      This is what I get when I export to excel.

       

      [font="courier"]BATCHDATE     TRANSTYPE     CUST     TRANSCODE     TRANSDATE     DEBIT     CREDIT     ACCTNUM     ACCTDESC     CCDESC     COSTCENTER

      20021216     SA     xxxxxxxxxxxxxxxxxxxx     1023510     20021216          2.70     1100     A/R TRADE     R RDU     10101000

      20021226     SA     xxxxxxxxxxxxxxxxxxxx     1021113     20021226          0.80     1100     A/R TRADE     R RDU     10101000

      20030106     SA     xxxxxxxxxxxxxxxxxxxx     1023232     20030106          0.80     1100     A/R TRADE     R RDU     10101000

      20030106     SA     XXXXXXXXXXXXXXXXXXXX     1023705     20030106          3.52     1100     A/R TRADE     R RDU     10101000

      20030110     SA     XXXXXXXXXXXXXXXXXXX     1023593     20030110     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030115     SA     XXXXXXXXXXXXXXXXXXX     1023711     20030115          6.40     1100     A/R TRADE     R RDU     10101000

      20030115     SA     XXXXXXXXXXXXXXXXXXX     1023814     20030115          23.14     1100     A/R TRADE     R RDU     10101000

      20030115     SA     XXXXXXXXXXXXXXXXXXX     1023865     20030115          3.20     1100     A/R TRADE     R RDU     10101000

      20030115     SA     XXXXXXXXXXXXXXXXXXX     1023753     20030115          1.28     1100     A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXXXXXX     1022615     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXXXXXX     1022497     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXXXXXX     1022782     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXXXXXX     1023700     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXXXXXX     1022887     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXXXXXX     1022939     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXX     1023628     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXX     1023570     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030121     SA     XXXXXXXXXXXXXXXXXXXX     1022938     20030121     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030204     SA     XXXXXXXXXXXXXXXXXXXX     1021999     20030204     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030204     SA     XXXXXXXXXXXXXXXXXXXX     1021906     20030204     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030204     SA     XXXXXXXXXXXXXXXXXXXX     1021836     20030204     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030228     SA     XXXXXXXXXXXXXXXXXXX     1023511     20030228     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030306     SA     XXXXXXXXXXXXXXXXXXX     1023712     20030306     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030306     SA     XXXXXXXXXXXXXXXXXXXX     1022168     20030306     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030306     SA     XXXXXXXXXXXXXXXXXXXX     1022248     20030306     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030306     SA     XXXXXXXXXXXXXXXXXXXX     1022440     20030306     0.00     1100.00          A/R TRADE     R RDU     10101000

      20030306     SA     XXXXXXXXXXXXXXXXXXXX     1022310     20030306     0.00     1100.00          A/R TRADE     R RDU     10101000

       

        /font[/quote]