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

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)