I'm importing data from an API into Excel via power query.
As some of the data is in fractions this is causing a bit of a nightmare. I can't use 'number' because of this and it throws an error, so I have to import as text.
When doing so the data imports as below, with a "'" in front:
As I need the data to update each minute, and then run formulas on it, I need this to be a number. What's the easiest way (either macro to convert to number from '15/2) or to fix Power Query and allow for it to import/convert fractions? (That would be perfect!)
Here's a macro to use (assuming your screenshot has the correct column placements). The only adjustment you need to make is adjust "intLastRow" with the last row of your data.