Changing Text/Value in Excel

hi, the value of a number i am pasting is 10 decimals long (ex: 55.4297804839) but i got the cell to show 1 decimal (55.4)

 

how can i change the value of the cell to 55.4 as well? i need to do this for a list of 50 numbers which is why i don’t want to manually do it. 

 

thanks. 

By: Emily Nguyen

One thought on “Changing Text/Value in Excel

  1. D N Maru

    Hi

    You can use Round or RoundUp or RoundDown functions (Choose one of these depending on your requirements). Assuming your data is in A1 then put following formula in B1

    =Round(A1,1)

Leave a Reply

Your email address will not be published. Required fields are marked *