[問題] excel 小數點前面的零補齊
我想請問各位大大
我在spss系統資料匯出excel 檔案後
小數點前面只要是零的部分都會消失
請問怎麼把這些零補齊呢?
http://i.imgur.com/OTR9Sbl.jpg
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 121.254.121.11
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1463104911.A.306.html
http://i.imgur.com/tvbyqQT.jpg
→
05/13 11:04, , 1F
05/13 11:04, 1F
→
05/13 11:08, , 2F
05/13 11:08, 2F
→
05/13 11:08, , 3F
05/13 11:08, 3F
→
05/13 11:10, , 4F
05/13 11:10, 4F
※ 編輯: yurakiwi (121.254.121.11), 05/13/2016 11:51:48
→
05/13 11:52, , 5F
05/13 11:52, 5F
→
05/13 11:53, , 6F
05/13 11:53, 6F
→
05/13 12:12, , 7F
05/13 12:12, 7F
→
05/13 12:12, , 8F
05/13 12:12, 8F
→
05/13 12:13, , 9F
05/13 12:13, 9F
→
05/13 12:15, , 10F
05/13 12:15, 10F
※ 編輯: yurakiwi (121.254.121.11), 05/13/2016 13:01:34
※ 編輯: yurakiwi (121.254.121.11), 05/13/2016 13:08:32
→
05/13 13:09, , 11F
05/13 13:09, 11F
→
05/13 13:11, , 12F
05/13 13:11, 12F
→
05/13 13:12, , 13F
05/13 13:12, 13F
→
05/13 13:13, , 14F
05/13 13:13, 14F
→
05/13 13:13, , 15F
05/13 13:13, 15F