Forum Discussion
Number format
As a Realtor I have, over the years, downloaded bulk MLS data for offline processing in Excel for the benefit of my buyer and seller clients. There was never a problem until the MLS service (Garden S...
In addition to the solution provided:
1. Convert the values to Excel Table using CTRL + T
2. In the Data tab, select From Table/Range
The data will be loaded into the Power Query editor and Power Query will automatically convert the text values to numbers! So easy!
Then you can select Close and Load to load the result back to Excel.
1. Convert the values to Excel Table using CTRL + T
2. In the Data tab, select From Table/Range
The data will be loaded into the Power Query editor and Power Query will automatically convert the text values to numbers! So easy!
Then you can select Close and Load to load the result back to Excel.
Thank you. I tried it and worked like a charm. I need to learn more about the Power Query Editor so I can understand what's going on and whether it will work with how my data is layed out.
- With Power Query, you can do so much effortlessly!