I have a huge several csv file of 20, 000 records each which I combine in power query , the csv has many headers however my header MTT_MCH has values with decimal points, but csv file itself digits appears text 1008 and should be reading 10.08.
All digits have two decimal places .
How to split the decimal number from text . from 1008 to 10.08 e.g 450 to 4.50 .
Is there a special M CODE that can do this in power query
Bookmarks