Forum Discussion
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 43230508682052000105651050000565451802220651 and in power query 4.3230508682052E+43
I ask for help on how to solve the power query.
Grateful.
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.
1 Reply
AjithPrasathResolver II
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.