Forum Discussion

curiouspbix0's avatar
curiouspbix0
Icon for Helper IV rankHelper IV
5 years ago
Solved

Text to > 2 Decimals

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 ?
Need Help
Show and Tell
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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