Forum Discussion

Las's avatar
Las
Frequent Visitor
4 years ago

Converting Text Column having Text and Scientific Notation

Hi Experts, I'm having a text columns with numbers, text and scientific notation, example as follows   202-203 2320042 AH3021 F21A-001 1.00E+11   In a situation like this how to handle the d...
Need Help
Las's avatar
Las
Frequent Visitor
4 years ago

Thanks for your response.

Currently i'm using a formula =TEXT(<Cell>, "0") in Excel. Looking for a similar solution in Power Query, at the end should be able to convert the column to TEXT.  

 

Ta.