Change Date Format in Excel Reports

Change Date Format in Excel Reports

Change Date Format in Excel Reports

1. Download file and open in Excel

2. Highlight cells containing dates
mceclip3.png
3. On the Data  tab, click Text to Columns
mceclip4.png

4. Click Next on step 1
mceclip5.png

5. Click Next on step 2
mceclip6.png

6. Select Date and MDY on step 3, then click Finish
mceclip7.png

7. Excel will bring you back to your spreadsheet.

mceclip8.png

8. With the dates still highlighted, right click on the highlighted area and select Format Cells
mceclip9.png

9. Choose the desired date format and click OK
mceclip10.png

10. Date format has been changed
mceclip11.png

    • Related Articles

    • 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 ...

    • Release Notes 24.11.0 - Coming November 12, 2024

      Release Notes 24.11.0 ✨ Enhancements Schedules: Trip Assist: Canceled bookings will no longer appear in trips or reports. Crew positions are now displayed in the header of scheduled trip reports. Flight Logs: New option to hide the FBO section in the ...