[問題] txt轉excel數字小數點後一堆零
(若是和其他不同軟體互動之問題 請記得一併填寫)
軟體:excel
版本:2010
我將txt檔
以資料匯入excel
在txt有一欄數據小數點後有一堆零
到excel之後還是保留著
調儲存格格式也沒用
需要重新key才會是正常數字
求解！！！
-----
Sent from JPTT on my Asus PadFone T004.
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 39.12.71.76
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1466066123.A.A1A.html
→
06/16 16:41, , 1F
06/16 16:41, 1F
→
06/16 16:41, , 2F
06/16 16:41, 2F
→
06/16 16:41, , 3F
06/16 16:41, 3F
→
06/16 16:41, , 4F
06/16 16:41, 4F
→
06/16 16:41, , 5F
06/16 16:41, 5F
→
06/16 16:41, , 6F
06/16 16:41, 6F
→
06/16 16:45, , 7F
06/16 16:45, 7F
→
06/16 17:18, , 8F
06/16 17:18, 8F
→
06/16 17:18, , 9F
06/16 17:18, 9F
→
06/16 17:32, , 10F
06/16 17:32, 10F
推
06/16 19:39, , 11F
06/16 19:39, 11F
→
06/16 19:40, , 12F
06/16 19:40, 12F
推
06/16 20:37, , 13F
06/16 20:37, 13F
→
06/16 20:39, , 14F
06/16 20:39, 14F
Office 近期熱門文章
PTT數位生活區 即時熱門文章