Forum Discussion

curiouspbix0's avatar
curiouspbix0
Helper 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!