[問題] Excel輸出逗號問題
版本: Excel 2003
問題:
因為想要處理資料，因為該軟體只能吃下面這種格式的檔案
77,77,1,1,72.5,76.5,70.9,67.5,72.9,Line_Iso77,0,1
82,82,1,1,71.3,78.8,71,67.8,75.1,Line_Iso82,0,1
90,90,1,1,77.3,79.9,78.8,70.2,73.8,Line_Iso90,0,1
但我看他在Excel裡面沒有到逗號，不知該怎樣自己做出這種格式
因為我嘗試在Excel裡面打上逗號 可是輸出後變成
"," 42 "," 1 "," 1 "," 43.54 "," 43.96 "," 42.81 "," 40.91 "," 43.68 "," PL42_1 "," 0 "," 1D
"," 46 "," 1 "," 1 "," 38.17 "," 40.18 "," 37.75 "," 36.94 "," 37.02 "," PL42_2 "," 0 "," 1D
逗號都會變成這樣，可以問問該怎解決
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 192.203.57.28
推
09/01 12:09, , 1F
09/01 12:09, 1F
→
09/01 12:10, , 2F
09/01 12:10, 2F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
