天气预报15天查询> 其他> EXCEL如何取整数

EXCEL如何取整数

更新时间: 2020-07-09 00:00:00     

方法如下:

1、在桌面上点击右键新建一个excel表格;

2、打开excel表格,输入一段数字;

3、在单元格B1中输入int(单元格位置除以100)乘100,然后点击回车键;

4、鼠标移动右下角的位置上,向下拖动,所有的数据就可以全部变成了整数;

5、或直接在开始中减少小数位数。

关键词: excel 如何 整数

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-3218975/ | 耗时:0.5385 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3218975 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3218975 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3218975 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2683980,111397,3207690,3234214,1077000,300805,1122120,108414,1052195,635613,107782,1601302,113721,114127,2915046,2679265,108830,108758,109049,2097228,1078114,146384,109260,2633004,107776,1130844,116167,1127027,110568,2194427) ORDER BY field (ArticleID,2683980,111397,3207690,3234214,1077000,300805,1122120,108414,1052195,635613,107782,1601302,113721,114127,2915046,2679265,108830,108758,109049,2097228,1078114,146384,109260,2633004,107776,1130844,116167,1127027,110568,2194427)