Forum Discussion
Solved
Problem with converting data
Hello everybody, my first post here. I am having problems with converting dates from text as follows: As you can see, there is no triangle at the upper left corner to indicate the error and th...
- Hello, what you need to do is simple
1. Click in the data and press CTRL + T to format as Excel Table
2. In the Get & Transform group in the Data tab, click on From Table/Range
The data will be loaded into the Power Query editor and the date will Automatically fix itself.
After that, just click on Close & Load... This will load back to the spreadsheet
ChrisMendoza thanks for your answer. That action replaces the same date for all cells :S
- Sorry, I thought it might work