ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Excel ¤é´ÁÂà´«爲 ¤¤°ê¼Æ¦r

Excel ¤é´ÁÂà´«爲 ¤¤°ê¼Æ¦r

¨Ò¦p A1 = 23/11/2012 (¤é´Á), ¦p¦óÅýB1Åã¥Ü/Âà´«爲¡i¤G¡³¤@¤G¦~¤Q¤@¤ë¤G¤Q¤T¤é¡j

·PÁ¤j¤j¤£§[½ç±Ð
ss

B1 =TEXT(A1,"[DBNum1]yyyy¦~m¤ëd¤é")
My Blog
http://blog.xuite.net/a8350070

TOP

¦^´_ 2# a8350070

·PÁÂ, ¥i§_¸Ñ»¡¤@¤U [dbnum1] ¥Îªk, ÁÙ¦³¨S¦³¨ä¥Ldbnum?
ss

TOP

[dbnum1] [dbnum2] [dbnum3] µ¥¬OÂù¦ì¤¸¼Æ¦r®æ¦¡.
[$-404] ¬OÁcÅ餤¤å [$-804] ¬O²Å餤¤å

TOP

¦^´_ 4# mannings

·PÁÂ, ¦³¥i¥HÂন­^¤åªº¶Ü?

¨Ò¦p: 101 => one hundred and one
ss

TOP

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD