Question

在Excel中如何让长串数字分段显示？如123456789显示成123 456 789？盼高手解决

Answer 1

选中该单元格----右键---设置单元格格式---自定义----类型中写入 0 000 000 ----确定

追问

银行账号有17位数，按照这样设置的话 最后几位全部显示是0，有没办法解决？

追答

17位的只能用公式来设置了,假设数字串写在A1单元格,则B1单元格写入公式
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,15,," "),12,," "),9,," "),6,," "),3,," ")
或
=REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(A1,3,," "),7,," "),11,," "),15,," "),19,," ")

Answer 2

设置单元格格式,自定义,输入
### ### ### ###

追问

银行账号有17位数，按照这样设置的话 最后几位全部显示是0，有没办法解决？