Traditional Culture Encyclopedia - Photography and portraiture - How to delete decimals from excel tables
How to delete decimals from excel tables
1. As shown in the figure, there are some numbers in the EXCEL table. Now you want to keep the integer. Double-click the number after the decimal point in the table and it will not appear.
2. If you only want to keep integers, just enter the function =trunc(A 1) in column B, as shown in the figure:
3. After the second step, press Enter, and then use fill handle to pull down the integer. Is it very simple, as shown in the figure:
- Previous article:Teaching plan of "bathing paper dolls" in middle class
- Next article:Information about Wu Shuang's father.
- Related articles
- What police officer schools are there in Jiangsu?
- The Best Place to See Red Leaves in Autumn in Wuhan in 2022
- What should I do if I am not satisfied with the intensive wedding photos? The standard of intensive wedding photos.
- Graduation shooting plan book
- Where is the best place to travel in summer?
- How many episodes are there in Kudou Shinichi vs Blackfield Haidong?
- The portrait has a halo.
- Who is older, Apollo or Kardashian?
- What kind of bank is Bank of Ningbo?
- What about Linyi Zhou Yong Trading Co., Ltd.?