返回目录：office365
打开WpS表，打开合计数据。
请选择2日列的第一行的数据。（我是C2。）点击“排序”。
选择日期后面的列。如果下一列有数据，则插入一列。
D列右键“单元格格式”
根据需要设置适当的日期格式。
在D2中输入公式＝VALE（SUBSTITUTTE（D2、“.”、“-”）。
将鼠标左下角移到D2的左下角。显示黑色固态“+”。按住鼠标左键向下拖动，然后进入表格数据的最后一行。
“，”创建时间“：0，“embrave”：“{”embrave类型“：0，”黄金计数“：0，”积分计数“：0，”奖励时间“：0}”，额外“{”来自香港“：”1”，“有答案“：”1”，“修改时间“：”1617791428”，“财产审查可见性“{”财产名称“：”审查可见性“，”财产价值“：”65”，“信心“：”空“，”编辑“，”理由代码“：”0，“理由信息“：”编辑时间“：”1615641270，”“1”、“搜索类型”：“ugc_活动”、“在_审查下搜索_”：“1”、“wd_来源”：“查询”、“wdh_客户_ip”：“127.0.0.1”），“新的_u答案_uuCNT”：0，“图片”：null，“pv”：33，“qid”：“6939125902043316488”，“问题状态”：0，“标题”：“WpS表格如何同时设置几十列？”？，“vl”：65}，“contentType”：“application/json；charset=utf-8，“fontStyle”：{“domains”：“lf6 awef.bytetos.com”、“lf3 awef.bytetos.com”、“filename”：“23a20e44d496857”、“base64”：数据：font/opentype；base64，T1RUTWAJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ0ZGIBN1D+QaaAAAAAAAAAAAAAAAAAAAAAAAAAAAYK9TLZK/SV8ZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaAaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaawAM 1NVDXJJJZUHHBLNHBNNTQWBTAG8ADQBYAGBAG8ACGBZAFMAQ05VCM1HBABOAG8ACGBTAGbFnDxJZUHBLNHBNNTQBYB3JTYWWAWWbWbWbWbWbWbHuaGbGbhag4ACWBTAEMAIABOAG8ACGBTAGfNdXJZUHBLNHBNNTQ0VCM1HBABOAG8ADQBYBYBYBYBYBYWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWUAcg Bjaguasabhag4auwbag4acwbatemaiababababababaaababababaaabaav41onyqkmc3//waaababxjwidhaqylf//AACodZdne/dn1gabaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababa9ybWF SU291CMNLSGFUUU2FUC1NDTM9YBWFSZ2LKMZM4MDJNAWQYMJQXM2DPZ2LKMJ3ODEAABIWGMAY0BJFAQEEBGKKDPEDOSOIW6LDOSOAAACIGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA数据：font/opentype；base64，T1RUTWAJAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ0ZGIBN1D+QaaAAAAAAAAAAAAAAAAAAAAAAAAAAAYK9TLZK/SV8ZAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaAaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaawAM 1NVDXJJJZUHHBLNHBNNTQWBTAG8ADQBYAGBAG8ACGBZAFMAQ05VCM1HBABOAG8ACGBTAGbFnDxJZUHBLNHBNNTQBYB3JTYWWAWWbWbWbWbWbWbHuaGbGbhag4ACWBTAEMAIABOAG8ACGBTAGfNdXJZUHBLNHBNNTQ0VCM1HBABOAG8ADQBYBYBYBYBYBYWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWbWUAcg Bjaguasabhag4auwbag4acwbatemaiababababababaaababababaaabaav41onyqkmc3//waaababxjwidhaqylf//AACodZdne/dn1gabaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababababa9ybWF SU291CMNLSGFUUU2FUC1NDTM9YBWFSZ2LKMZM4MDJNAWQYMJQXM2DPZD4OTU3Z2LKMJ3OdeaaaABiWGmaY0BJGAFAFAQEEBGKDPKEDOSOIW6LDOSOAACIGAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=”，url（“https://lf6-awef.bytetos.com/obj/awesome-font/c/23a20e44d496857.woff2 ）格式（“woff2”），url（“https://lf3-awef.bytetos.com/obj/awesome-font/c/23a20e44d496857.woff2 ）格式（“woff2”），url（“ https://lf6-awef.bytetos.com/obj/awesome-