作者查詢 / Scorpio1104

總覽項目：發文 | 留言 | 暱稱

作者 Scorpio1104 在 PTT [ Office ] 看板的留言(推文), 共7則

限定看板：Office

看板排序：

全部CVS2089Bank_Service829Post818IC-Card538Nangang454creditcard448Lifeismoney413Bus310Neihu273einvoice261Delivery234library229Zastrology211Scorpio198HsinYi187ask123Shu-Lin110ShuangHe110SongShan110Taipei107TY_Research72MRT67Capricornus40SK_SD_PL40Browsers35BusTimes26hypermall25Libra23BigBanciao22Starbucks22Taiwan31918Coffee16part-time15Railway15Sijhih15AntiVirus14SMSlife13SYSOP11Daan9IME9share9Instant_Mess8tax8Virgo8Actuary7Office7Bunco6e-coupon5PttNewhand5Barista4Gemini4finding3Mind3NUU_Talk3Pisces3stationery3Taurus3Zhongshan3Aviation2book2CHU2CYCU_Talk2dog2drawing2Keelung2Leo2NCCU09_Stat2North_Coast2PttBug2regimen2t-management2You_out2Anti-ramp1Aries1AskBoard1ayaka1Beatles1BigPeitou1BigShiLin1consumer1CSMU-MED971CUST1CYSH97Y3181Disabled1EarthScience1Emulator1eWriter1FCSH_Club1Hwh_mis588a1IVERSON1KNU-IEC1KR_1N2D1KSU1Kuroyume1Leehom1LeeJoonGi1Liu1MuscleBeach1N_Masami1NBAGAME1NCCU1NCCU07_Ghis1NCCU_RELIPHI1NCHU-FIN971NCHU_MKT961NCYU_Fst_981NCYU_GC_G971NDHU_FIN981NHCUE_Rover1NHU_LD921NIU-ECE92b1NKSHS1ntnuch92b1NTUE_NSE1001NTUEtalk1NTUIAM-3261NTUST-MBA971NUK_AC1001NUU-SHE-971PSJH5-3051PSWO3rd1RailTimes1Road_Running1SGS_Online1SHU-CMBA961SHU-CMBA971single1SpecialForce1TKU_S92BIO1Vocaloid1Wallpaper1WinMine1WorldCup1Yakyu_spirit1Yon1YoungChi3061YuiAragaki1Zhongzheng1<< 收起看板(138)

首頁

上一頁

1

下一頁

尾頁

[算表] 要怎麼完全移除儲存格格式

[ Office ]4 留言, 推噓總分: +1

作者: smartalex - 發表於 2008/11/09 22:00(15年前)

1^F推Scorpio1104:Ctrl+1→數值→自訂→輸入 yyyy/mm/dd →確定11/09 23:03

2^F→Scorpio1104:yyyy=西元年(4碼),mm=月份(2碼),dd=日期(2碼)11/09 23:06

3^F→Scorpio1104:月份、日期為個位數會自動補011/09 23:08

4^F→Scorpio1104:Ps. yy=西元年(末2碼),e=民國年(不限位數)11/09 23:09

[算表] 讓每一列自動累加要怎麼弄@@?

[ Office ]10 留言, 推噓總分: +3

作者: ficecmiraror - 發表於 2008/11/09 19:21(15年前)

1^F推Scorpio1104:用複製控點，讓它自動填滿？11/09 19:57

8^F推Scorpio1104:若為連續n筆資料，可在複製控點上直接按2次滑鼠左鍵,11/09 22:58

9^F→Scorpio1104:第2~n筆會自動填滿，不需要拖曳它.11/09 22:59

首頁

上一頁

1

下一頁

尾頁