try format>custom format>0000

来源: 于 2005-10-19 09:30:36 [旧帖] [给我悄悄话] 本文已被阅读：次

hightlight the whole column, right click
format cells --> custome format--->type: 0000

4 zeros is the length of your number