Are you receiving SNAP/EBT benefits? The Expensify.org/SNAP-VAX campaign is live and accepting new members. Learn more about receiving $50 for submitting a SNAP receipt and $50 for getting your COVID-19 vaccine here and join today!
How-to: Display report IDs or transactionIDs correctly in Excel
When opening a CSV file in Excel it will automatically register report IDs and transcactionIDs as numbers and assign the number format to the report ID column. If a number is greater than a certain length, Excel will contract the number and display it in the exponential form. To prevent this the number needs to be imported as text. To do this,
Open Excel and click File > Import > select your CSV file > follow the prompts and on step 3 set the report ID/transactionID column to import as Text: