軟體:EXCEL
版本:2003
假設我把儲存格格式自訂"2/"G/通用格式
那我只要在儲存格輸入15
那一格自動就會帶出2/15
但好像只能限於輸入數字
有沒有辦法我只輸入
"信用卡1"
儲存格自動就帶出"信用卡1繳費期限"
謝謝!!
推
02/16 21:21, , 1F
02/16 21:21, 1F
推
02/16 21:24, , 2F
02/16 21:24, 2F
不懂@@
我的意思是假設有一整列,我只要輸入"信用卡1"
儲存格就會自動顯示"信用卡1繳費期限"
輸入"信用卡2",儲存格自動顯示"信用卡2繳費期限"
也就是"繳費期限"這幾個字是固定的
我只要輸入前面"信用卡*"就可以了
不知道懂不懂我的意思...
謝謝各位!
※ 編輯: xemerald 來自: 114.44.111.197 (02/16 21:35)
※ 編輯: xemerald 來自: 114.44.111.197 (02/16 21:36)
推
02/16 21:35, , 3F
02/16 21:35, 3F
→
02/16 21:36, , 4F
02/16 21:36, 4F
推
02/16 21:39, , 5F
02/16 21:39, 5F
→
02/16 21:40, , 6F
02/16 21:40, 6F
→
02/16 21:40, , 7F
02/16 21:40, 7F
→
02/16 21:43, , 8F
02/16 21:43, 8F
→
02/16 21:44, , 9F
02/16 21:44, 9F
→
02/16 21:44, , 10F
02/16 21:44, 10F
→
02/16 21:44, , 11F
02/16 21:44, 11F
→
02/16 21:45, , 12F
02/16 21:45, 12F
推
02/16 21:48, , 13F
02/16 21:48, 13F
→
02/16 21:49, , 14F
02/16 21:49, 14F
→
02/16 21:50, , 15F
02/16 21:50, 15F
→
02/16 21:51, , 16F
02/16 21:51, 16F
推
02/16 21:55, , 17F
02/16 21:55, 17F
→
02/16 21:56, , 18F
02/16 21:56, 18F
推
02/16 21:58, , 19F
02/16 21:58, 19F
推
02/16 21:58, , 20F
02/16 21:58, 20F
→
02/16 21:58, , 21F
02/16 21:58, 21F
→
02/16 21:58, , 22F
02/16 21:58, 22F
→
02/16 22:00, , 23F
02/16 22:00, 23F