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 "'" infront:
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!).