¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á µM«á©T©w¤£ÅÜ «ç¼Ò°µ©O
- ©«¤l
- 7
- ¥DÃD
- 1
- ºëµØ
- 0
- ¿n¤À
- 27
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows
- ³nÅ骩¥»
- Win7
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-9-14
- ³Ì«áµn¿ý
- 2013-5-5
|
A1:99¦~10¤ë13¤é
¤½¦¡:=FIXED(YEAR(NOW())-1911,0,TRUE)&"¦~"&FIXED(MONTH(NOW()),0,TRUE)&"¤ë"&FIXED(DAY(NOW()),0,TRUE)&"¤é"
vba
Sub Macro1()
Range("B1") = Range("A1")
End Sub
A1:99¦~10¤ë13¤é(¬°¤½¦¡)
B1:99¦~10¤ë13¤é (¬°¤å¦r)§Y¬°·í®É§@·~¤é´Á
----------------------------------------------------------------------
²³æ»¡©ú¦p¤W...(´ú¸Õ«á没°ÝÃD) |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|