copy decimals but pasting only 6 digits

[lezawang]

Hi
I have numbers like this. I want to copy them and paste them in another sheet/file but I want only keep the 6 digits after the decimal.
Is there any fast and easy way to do that? Thank you very much.

Book1
	A	B	C
1	Copy		When I paste it in different sheet/file
2	1.678520541		1.678520
3	0.27682547		0.276825
4	1.59243108
5	1.678520541
6	0.27682547
7	1.59243108
8	1.148156579
9	1.138317784
Sheet2

 

[rlv01]

Why not change the number formatting in Col A to only display 6 places after the decimal point? That way when you copy/paste, that format will carry over to the new sheet.

 

[lezawang]

Why not change the number formatting in Col A to only display 6 places after the decimal point? That way when you copy/paste, that format will carry over to the new sheet.

Thanks for your help but these numbers are coming from formulas like but I just tried to put the numbers here. Sorry my mistake.