TIPS-Excel

Tips in Excel

Attribution: maricq@ieee.org

Importing a CSV file with US formated dates and saving in excel with EU formated dates

1. Open Excel
2. Goto Data tab
3. Button "Get data from power query", browse and load csv file [next]
4. Button “Transform data” (lower right)
5. Data type (menu bar top right side) select choose using locale
6. Enter Data type DATE and Locale English (United States, Computer)
7. Button "Close and load"
8. EOF