Excel: Date Reformatting of an entire column

05-16-2018 15:12
  1. Highlight the column
  2. Hit ALT, a, e on your keyboard (or Go To Data on the ribbon, Select "Text to Columns"
  3. At Step 1 hit Next
  4. At Step 2 hit Next
  5. At Step 3 click Date, then Finish
  6. Highlight the column again
  7. Hit CTRL + 1 on your keyboard (or Right click and select Format Cells) and select the Date format
Tags: Excel
Average rating: 0 (0 Votes)

You cannot comment on this entry