Format of column information

[amgelain]

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.

[AjithPrasath · Accepted solution]

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.