[算表] EXCEL如何在一串數列前面補零?
軟體:
EXCEL
版本:
2000
有一欄數列分別為:
S-1
S-2
S-3
S-4
....
...
..
S-10
S-11
以此類推
請問要如何轉成如下三位數字之型式呢?
S-001
S-002
S-003
S-004
....
...
..
S-010
S-011
感激不盡!~
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.41.207.6
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1447170276.A.C28.html
→
11/10 23:49, , 1F
11/10 23:49, 1F
→
11/11 00:21, , 2F
11/11 00:21, 2F
→
11/11 00:21, , 3F
11/11 00:21, 3F
→
11/11 00:50, , 4F
11/11 00:50, 4F
→
11/11 00:58, , 5F
11/11 00:58, 5F
→
11/11 00:59, , 6F
11/11 00:59, 6F
→
11/11 01:00, , 7F
11/11 01:00, 7F
→
11/11 01:00, , 8F
11/11 01:00, 8F
→
11/11 01:05, , 9F
11/11 01:05, 9F
Office 近期熱門文章
PTT數位生活區 即時熱門文章