Forum Discussion

Salman_Alkweldy

Copper Contributor

Oct 23, 2023

Dates Columns imported from Planner are not correct

Hi Guys, I exported some Plans from Planner to Excel, all is fine except for the date columns, they are exported as texts. for example, please see below snap shot: The highlted cells...

Riny_van_Eekelen

Platinum Contributor

Oct 23, 2023

Salman_Alkweldy You need to transform the text dates in column H to real dates with Text-to-columns on the Data ribbon. Skip through steps 1 and 2 (i.e. change nothing). In step 3 set the data format to 'Date' and indicate that the texts are in 'DMY' format and Finish.

Now, Excel will transform the texts to real dates and display them in the default date format based on your local system settings.

Ibrahim_Sayyed
Copper Contributor
Mar 10, 2024
Riny_van_Eekelen

Solution described does work partially. "Created Date" column got converted in MMM-DD-YYYY format however rest two columns i.e. "Start Date" & "Due Date" didnot converted. infact excel file is closing abruptly.

Created Date Start Date Due Date
03/08/2024 03/12/2024 03/15/2024
03/08/2024 03/08/2024 03/11/2024
03/07/2024 03/07/2024
- SergeiBaklan
  Diamond Contributor
  Mar 10, 2024
  Ibrahim_Sayyed
  
  Text to Columns work on column by column basis. That means you shall repeat the procedure for each column separately.
  
  Based on your screenshot on third step of the wizard it shall be selected Date->MDY.
  
  This tool is in Excel for dozens of years. If you do all correctly it shall work.
  - Neil
    Copper Contributor
    Dec 10, 2024
    I stumbled upon this thread hoping for a resolution, but unfortunately excel keeps abruptly crashing (along with any other open/minimised excel files) as soon as I try doing the text to columns on the "Due Date" column. It is unfortunate that despite both being MS platforms, they are so incompatible. It's like Excel hates columns with Dates

Resources