Solved: Powerquery + convert scientific notation?

Hi,

I am new to Powerquery. I want to use PowerQuery to convert a string of 13 characters to numbers which is now in 1234E+12 format, so I can actually see the values after I 'Load & exit'.

I tried to convert to number, decimals, text, trim/uppercase and used a formula* I found on the web all without luck. Anyone who know how to solve this?

*=Number.ToText(Number.From(#ISBN],"G"))

What happens with this last formula is that my value is 9589058710093 but PQ convert it to a round 100 so it becomes 9789058710100.

Thanks in advance

Re: problem was I was new.... I promoted headers which I shouldnt. I removed the promote headers and all was fine.