title: Change the data type of a column that contains text and number in Power BI Query
body: <p>I am struggling with a simple data type change. 
  I have a column that contains both text (string) and numbers. This column is computed from a simple formula. Both the text and the numbers are important, so I need to keep them both in the same column. </p>
  
  <p>What I would like to do is just to reduce the number of decimals of the numbers. Unfortunately, I cannot do that, as the data type is "Any". If I change the data type to "Decimal number", the text values show an error.</p>
  
  <p>Is there a way to somehow change the data type only of the number values and to not affect the text? Or just to reduce the number of decimals of the numbers?</p>
  
  <p>Attached is a picture with the current situation: the number displayed is just the result of a subtraction. </p>
  
  <p>Thank you for the help!</p>
  
  <p><a href="https://ibb.co/C7yFH5F" rel="nofollow noreferrer">https://ibb.co/C7yFH5F</a></p>