Try this

=ROUND(TRIM(SUBSTITUTE(A1,CHAR(160),CHAR(32))),2)


On Sep 23, 5:26*am, Harshad wrote:
I copy data from one website and paste it to excel sheet. The value which is
copied is like 180.12098400983000, 20.000002300000, 79.120000,
130.25999999999999
like this, i have so many data. I can't do formate cell number check
1234.10. each time. Infact, formate cell number check 1234.10, this process
also not any result.

i want to do it with a click or two.

Someone pls suggest