cancel
Showing results for 
Search instead for 
Did you mean: 
HangLin
Occasional Member - Level 2

Extract data getting Trailing zeros in CSV file when invoice number is long.

HI,

 

I have been running into issue where OCR captures the correct invoice number (IE #123456789101112) but when extracted in CSV, it turns into scientific notation which is an excel limitation due to exce.  However, when click on the cell I see that it has truncated first 6 digit with trailing zeroes #123456000000000.  This only happens when invoice # is long. Is this a concur issue? Thanks.

1 REPLY 1
HangLin
Occasional Member - Level 2

please close this topic, we have figured out that this is not a concur issue. Thanks.