您好，有关excel的答疑，请到excel大本营里面提问，不要在会计答疑群问，excel那边有专职高手答疑，谢谢。

您好，您的图片单元格里有文本，不能直接运算

你好 在 数据/数据验证 中修改相关内容

同学，你好 你发票导入的格式不对 你需要从开票软件下载好格式表格

直接修改制单人的名称，管理员在权限分配时。更改制单人的问题：由应收应付模块或其他模块生成的凭证，假如应由C02制单，你搞成C01了，更换操作员为C02，在相应模块查找需要修改的凭证，凭证修改下摘要如加个空格，即可把制单人换成C02。

你好同学看看这个有具体操作过程！ https://7dapi7.smartapps.baidu.com/pages/article/article?eid=154b4631a4b48569cb8f4138&scene=10810008&from=&_swebfr=1&_swebFromHost=vivobrowser&bdswankey=vivobrowser%3A%2F%2Fswan%2FGeVyFwtN81ARbPF3GIbuaPlRPT3SfzYB%2Fpages%2Farticle%2Farticle%3Feid%3D154b4631a4b48569cb8f4138%26word%3D4%25E8%25A1%258C%25E7%259A%2584%25E5%25AD%2597%25E5%25A4%258D%25E5%2588%25B6%25E5%259C%25A8%25E4%25B8%2580%25E8%25A1%258C%25E6%2580%258E%25E4%25B9%2588%25E6%2593%258D%25E4%25BD%259C%26oauthType%3Dsearch%26searchParams%3D%257B%2522failUrl%2522%253A%2522https%253A%252F%252Fjingyan.baidu.com%252Farticle%252F154b4631a4b48569cb8f4138.html%2522%252C%2522logParams%2522%253A%2522pu%253D%2524pu%2526baiduid%253D%2524baiduid%2526tcreq4log%253D1%2526isAtom%253D1%2526cyc%253D1%2526clk_info%253D%257B%255C%2522tplname%255C%2522%253A%255C%2522www_jingyan_normal%255C%2522%252C%255C%2522srcid%255C%2522%253A1599%252C%255C%2522ivkStatus%255C%2522%253A%255C%2522new_ivk_success%255C%2522%252C%255C%2522type%255C%2522%253A%255C%2522xcx%255C%2522%252C%255C%2522naType%255C%2522%253A%255C%2522%255C%2522%252C%255C%2522ivkSource%255C%2522%253A%255C%2522h5_schema%255C%2522%252C%255C%2522jumpType%255C%2522%253A%255C%2522xcx%255C%2522%252C%255C%2522jumpId%255C%2522%253A110%252C%255C%2522xcx_path%255C%2522%253A%255C%2522%2525252Fpages%2525252Farticle%2525252Farticle%2525253Feid%2525253D154b4631a4b48569cb8f4138%255C%2522%252C%255C%2522xcx_id%255C%2522%253A%255C%2522GeVyFwtN81ARbPF3GIbuaPlRPT3SfzYB%255C%2522%252C%255C%2522xcx_from%255C%2522%253A%255C%25221081000810003000%255C%2522%257D%2526lid%253D8136188885506825130%2526l%253D1%2526t%253Diphone%2526ref%253Dwww_iphone%2526from%253D1019311a%2526order%253D1%2526w%253D0_10_4%25E8%25A1%258C%25E7%259A%2584%25E5%25AD%2597%25E5%25A4%258D%25E5%2588%25B6%25E5%259C%25A8%25E4%25B8%2580%25E8%25A1%258C%25E6%2580%258E%25E4%25B9%2588%25E6%2593%258D%25E4%25BD%259C%2526tj%253Dwww_jingyan_normal_1_0_10_l%2526src%253Dhttps%2525253A%2525252F%2525252Fjingyan.baidu.com%2525252Farticle%2525252F154b4631a4b48569cb8f4138.html%2522%257D%26useTpl%3D1

你点击右键，选择数值，然后，选择保留2位小数就可以。

你好同学看看具体操作过程！ https://7dapi7.smartapps.baidu.com/pages/article/article?eid=154b4631a4b48569cb8f4138&scene=10810008&from=&_swebfr=1&_swebFromHost=vivobrowser&bdswankey=vivobrowser%3A%2F%2Fswan%2FGeVyFwtN81ARbPF3GIbuaPlRPT3SfzYB%2Fpages%2Farticle%2Farticle%3Feid%3D154b4631a4b48569cb8f4138%26word%3D4%25E8%25A1%258C%25E7%259A%2584%25E5%25AD%2597%25E5%25A4%258D%25E5%2588%25B6%25E5%259C%25A8%25E4%25B8%2580%25E8%25A1%258C%25E6%2580%258E%25E4%25B9%2588%25E6%2593%258D%25E4%25BD%259C%26oauthType%3Dsearch%26searchParams%3D%257B%2522failUrl%2522%253A%2522https%253A%252F%252Fjingyan.baidu.com%252Farticle%252F154b4631a4b48569cb8f4138.html%2522%252C%2522logParams%2522%253A%2522pu%253D%2524pu%2526baiduid%253D%2524baiduid%2526tcreq4log%253D1%2526isAtom%253D1%2526cyc%253D1%2526clk_info%253D%257B%255C%2522tplname%255C%2522%253A%255C%2522www_jingyan_normal%255C%2522%252C%255C%2522srcid%255C%2522%253A1599%252C%255C%2522ivkStatus%255C%2522%253A%255C%2522new_ivk_success%255C%2522%252C%255C%2522type%255C%2522%253A%255C%2522xcx%255C%2522%252C%255C%2522naType%255C%2522%253A%255C%2522%255C%2522%252C%255C%2522ivkSource%255C%2522%253A%255C%2522h5_schema%255C%2522%252C%255C%2522jumpType%255C%2522%253A%255C%2522xcx%255C%2522%252C%255C%2522jumpId%255C%2522%253A110%252C%255C%2522xcx_path%255C%2522%253A%255C%2522%2525252Fpages%2525252Farticle%2525252Farticle%2525253Feid%2525253D154b4631a4b48569cb8f4138%255C%2522%252C%255C%2522xcx_id%255C%2522%253A%255C%2522GeVyFwtN81ARbPF3GIbuaPlRPT3SfzYB%255C%2522%252C%255C%2522xcx_from%255C%2522%253A%255C%25221081000810003000%255C%2522%257D%2526lid%253D8136188885506825130%2526l%253D1%2526t%253Diphone%2526ref%253Dwww_iphone%2526from%253D1019311a%2526order%253D1%2526w%253D0_10_4%25E8%25A1%258C%25E7%259A%2584%25E5%25AD%2597%25E5%25A4%258D%25E5%2588%25B6%25E5%259C%25A8%25E4%25B8%2580%25E8%25A1%258C%25E6%2580%258E%25E4%25B9%2588%25E6%2593%258D%25E4%25BD%259C%2526tj%253Dwww_jingyan_normal_1_0_10_l%2526src%253Dhttps%2525253A%2525252F%2525252Fjingyan.baidu.com%2525252Farticle%2525252F154b4631a4b48569cb8f4138.html%2522%257D%26useTpl%3D1