天气预报 > 科技 > Excel如何正确输入身份证号码呢
Excel如何正确输入身份证号码呢
更新时间: 2021-05-16 19:53:47  

1、首先打开Excel表格;

2、输入身份证号码;

3、输入后,身份证号码格式出现错误,我们选择数字;

4、点击鼠标右键,选择设置单元格格式;

5、选择文本;

6、点击确定;

7、重新输入身份证号码就可以了,而且可以看到数字前面的小三角形。

关键词: excel 如何 正确 输入 身份证 号码

Excel如何正确输入身份证号码呢相关经验

天气预报

最新推荐

页面:/news/view-489550/ | 耗时:0.9641 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=489550 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=489550 LIMIT 0,1
select * from tbl_Articles_sphinx where id=489550 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(862861,508939,1764733,2957650,1040872,3494614,1208735,694607,2730628,1910604,2087627,868259,419315,847620,844956,553313,1188334,2876866,3117489,2947721,3445181,3211955,510424,2343598,3057385,942141,3273615,860751,548682,613605) ORDER BY field (ArticleID,862861,508939,1764733,2957650,1040872,3494614,1208735,694607,2730628,1910604,2087627,868259,419315,847620,844956,553313,1188334,2876866,3117489,2947721,3445181,3211955,510424,2343598,3057385,942141,3273615,860751,548682,613605)