发布网友 发布时间:2022-04-30 23:00
共3个回答
热心网友 时间:2022-06-20 00:13
选中你想加上括号的区域,单击“格式\单元格”,在“数字”里选择“自定义”,在“类型”下面填上:(0),点“确定”就行了,如图所示:热心网友 时间:2022-06-20 00:13
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,0,"(0)"),1,"(1)"),2,"(2)"),3,"(3)"),4,"(4)"),5,"(5)"),6,"(6)"),7,"(7)"),8,"(8)"),9,"(9)")热心网友 时间:2022-06-20 00:13
把所有单元格格式设置成文本格式