- ©«¤l
- 560
- ¥DÃD
- 159
- ºëµØ
- 0
- ¿n¤À
- 723
- ÂI¦W
- 0
- §@·~¨t²Î
- WINDOWS
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2014-9-10
- ³Ì«áµn¿ý
- 2023-10-31
|
DEAR ALL ¤j¤j
1.©ó Sheet4.Range("U2")®Ñ¼g²[¼Æ
=TEXT(Y2,"000-00-00") °õ¦æ²[¼ÆµL°ÝÃD
2.§ï¼g¬° VBA ¦p¤U µLªk°õ¦æ.
Sub BB()
Sheet4.Range("U2") = Text(Sheet4.Range("Y2"), "000-00-00")
End Sub
3.¦p¦ó§ï²[¼Æ¬°VBA ·Ð¤£§[½ç±Ð THANKS*10000 |
|