vlookup search value is date value~
but 2007/03/23 = 39164~
除在係 ' 2007/03/23之外
仲有冇其他方法呢????
thx~thx~
vlookup problem
2007-03-23 7:46 pm
回答 (1)
2007-03-23 8:04 pm
✔ 最佳答案
2007/03/23 = 39164 --> 你之後去 "儲存格格式" (mouse按right) 轉返佢做 "日期" 便可以. 希望幫到你喇.... :p
收錄日期: 2021-04-13 00:17:25
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070323000051KK00888