Change Date Format in Excel Reports
Change Date Format in Excel Reports
1. Download file and open in Excel
2. Highlight cells containing dates
3. On the Data tab, click Text to Columns
4. Click Next on step 1
5. Click Next on step 2
6. Select Date and MDY on step 3, then click Finish
7. Excel will bring you back to your spreadsheet.
8. With the dates still highlighted, right click on the highlighted area and select Format Cells
9. Choose the desired date format and click OK
10. Date format has been changed
Related Articles
Reports Menu
Overview The main reports tab serves as a central hub for accessing various reports that provide insights into key operational metrics and activities. These reports help streamline operations, support decision making, and ensure regulatory ...How to: Change a Trip to a Different Aircraft, Date or Trip Number
How to: Change a trip to a different aircraft, date or trip number. Learn how to change a trip to a different aircraft, date or trip number. Click here to view video.eAPIS Password Change
Overview Approximately every 90 days, CBP will require you to update your password in their portal. After making updating, you must also update the password in BART. Updating Password in BART 1. Update password in CBP portal then log into BART 2. ...Flight Tax Systems Interface
Overview Flight Tax Systems has approved an output format outlined in this article in order to interface with their system. The report must be built in Report Builder first. Once created, the report must be run one aircraft at a time. Create Report ...Report Builder
Using Report Builder. Report builder is a robust reporting tool that puts you in control of your data and reports. No programming or additional fees required. Create and re-use reports based on flights, expenses, passengers, and crew. Build excel and ...