Forum Discussion
Solved
Format of column information
Hello, In the excel file, the column content has complete information, but when importing it into the power query, there is a change in the format. Example: in excel it appears 432305086820520001...
Hi,
In Power Query, the default behavior is to display large numbers in scientific notation (such as 4.3230508682052E+43) when they exceed a certain threshold. To solve this:
#"Modified Step" = Text.From(Number.ToText(43230508682052000105651050000565451802220651, "G"))
By applying this modification, the number should be displayed as the original format (43230508682052000105651050000565451802220651) in Power Query.
Best Regards,
Ajith Prasath
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
