12345,12345,12345,1234如何在Excel表格中设置条件,也就是说数字5个一组用逗号隔开,最后的4个一组如11111,22222,33333,444412323,21321,32435,3453我希望在这样设置之后,输入数字时能够一目了然,容易核对另
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 02:18:47
![12345,12345,12345,1234如何在Excel表格中设置条件,也就是说数字5个一组用逗号隔开,最后的4个一组如11111,22222,33333,444412323,21321,32435,3453我希望在这样设置之后,输入数字时能够一目了然,容易核对另](/uploads/image/z/352294-70-4.jpg?t=12345%2C12345%2C12345%2C1234%E5%A6%82%E4%BD%95%E5%9C%A8Excel%E8%A1%A8%E6%A0%BC%E4%B8%AD%E8%AE%BE%E7%BD%AE%E6%9D%A1%E4%BB%B6%2C%E4%B9%9F%E5%B0%B1%E6%98%AF%E8%AF%B4%E6%95%B0%E5%AD%975%E4%B8%AA%E4%B8%80%E7%BB%84%E7%94%A8%E9%80%97%E5%8F%B7%E9%9A%94%E5%BC%80%2C%E6%9C%80%E5%90%8E%E7%9A%844%E4%B8%AA%E4%B8%80%E7%BB%84%E5%A6%8211111%2C22222%2C33333%2C444412323%2C21321%2C32435%2C3453%E6%88%91%E5%B8%8C%E6%9C%9B%E5%9C%A8%E8%BF%99%E6%A0%B7%E8%AE%BE%E7%BD%AE%E4%B9%8B%E5%90%8E%2C%E8%BE%93%E5%85%A5%E6%95%B0%E5%AD%97%E6%97%B6%E8%83%BD%E5%A4%9F%E4%B8%80%E7%9B%AE%E4%BA%86%E7%84%B6%2C%E5%AE%B9%E6%98%93%E6%A0%B8%E5%AF%B9%E5%8F%A6)
12345,12345,12345,1234如何在Excel表格中设置条件,也就是说数字5个一组用逗号隔开,最后的4个一组如11111,22222,33333,444412323,21321,32435,3453我希望在这样设置之后,输入数字时能够一目了然,容易核对另
12345,12345,12345,1234如何在Excel表格中设置条件,也就是说数字5个一组用逗号隔开,最后的4个一组
如11111,22222,33333,4444
12323,21321,32435,3453
我希望在这样设置之后,输入数字时能够一目了然,容易核对
另外给个身份证的设置:6位,8位,4位
12345,12345,12345,1234如何在Excel表格中设置条件,也就是说数字5个一组用逗号隔开,最后的4个一组如11111,22222,33333,444412323,21321,32435,3453我希望在这样设置之后,输入数字时能够一目了然,容易核对另
自定义类型中输入:
00000","00000","00000","0000