Text to > 2 Decimals

[curiouspbix0]

Hello PQ Experts, 

On Power Query, Text when converted to Number results with only 2 decimals.

How do I convert to Text to Number but retain all decimal values ?

[v-kelly-msft]

Hi  @curiouspbix0 ,

Is your issue solved now?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[v-kelly-msft · Accepted solution]

Hi @curiouspbix0 ,

How do you convert to number?As tested here,it keeps all the decimals.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[mahoneypat]

Not sure what you mean.  Can you provide some sample text values you are converting to text?  Are you using the Number.FromText function?

Pat

[RJ251997]

Hi @curiouspbix0 ,

Go to that link its helpful for you .

https://eriksvensen.wordpress.com/2018/03/06/extraction-of-number-or-text-from-a-column-with-both-te...

https://eriksvensen.wordpress.com/2018/03/06/extraction-of-number-or-text-from-a-column-with-both-te...

Thank & Regards 

Rohit Jaiswal

[curiouspbix0]

That would not help as resultant would get rid of decimal itself retrieving just numbers