lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
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 |