excel怎样把小数点后两位的变成一位就是怎样才能保留一位小数点,把两位的四舍五入为一位,没有的在后面加个零,比如8改成8.0,7.66改成7.7,把一列全改成这样的批量修改,谢过了!
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/29 18:37:27
![excel怎样把小数点后两位的变成一位就是怎样才能保留一位小数点,把两位的四舍五入为一位,没有的在后面加个零,比如8改成8.0,7.66改成7.7,把一列全改成这样的批量修改,谢过了!](/uploads/image/z/5060229-69-9.jpg?t=excel%E6%80%8E%E6%A0%B7%E6%8A%8A%E5%B0%8F%E6%95%B0%E7%82%B9%E5%90%8E%E4%B8%A4%E4%BD%8D%E7%9A%84%E5%8F%98%E6%88%90%E4%B8%80%E4%BD%8D%E5%B0%B1%E6%98%AF%E6%80%8E%E6%A0%B7%E6%89%8D%E8%83%BD%E4%BF%9D%E7%95%99%E4%B8%80%E4%BD%8D%E5%B0%8F%E6%95%B0%E7%82%B9%2C%E6%8A%8A%E4%B8%A4%E4%BD%8D%E7%9A%84%E5%9B%9B%E8%88%8D%E4%BA%94%E5%85%A5%E4%B8%BA%E4%B8%80%E4%BD%8D%2C%E6%B2%A1%E6%9C%89%E7%9A%84%E5%9C%A8%E5%90%8E%E9%9D%A2%E5%8A%A0%E4%B8%AA%E9%9B%B6%2C%E6%AF%94%E5%A6%828%E6%94%B9%E6%88%908.0%2C7.66%E6%94%B9%E6%88%907.7%2C%E6%8A%8A%E4%B8%80%E5%88%97%E5%85%A8%E6%94%B9%E6%88%90%E8%BF%99%E6%A0%B7%E7%9A%84%E6%89%B9%E9%87%8F%E4%BF%AE%E6%94%B9%2C%E8%B0%A2%E8%BF%87%E4%BA%86%21)
xS]OS1+H9mOO{j0:l
l2ƫ "L j c~Dc<+&ƄҘ4mx}2 Ti[Z_ʊil]85kiuz^n0M[^K[%g{yr_^:s~l,I[gW~8#WwhVֻgϞ]?ucx'd`QLy,
N{-%r-4ܹk:[1K*&ӼX=|$;{t8'GA l狾9ؗY6x>x d@PM͎#C̐#9pJtT%VL`
D%'HD13u`BK,j
"s.ZDhh,ĿAa"_i*i?vjҿhW