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

[µo°Ý] Excel ¨ç¼Æ Value() ¶Ç¦^¿ù»~­Èªº°ÝÃD

[µo°Ý] Excel ¨ç¼Æ Value() ¶Ç¦^¿ù»~­Èªº°ÝÃD

½Ð±Ð¥ý¶i

¦]¬°¦b±N Excel ¤u§@ªí¸ê®Æ ¶×¤J Access ¸ê®Æ®wªº¹Lµ{¡Aµo¥Í¿ù»~°ÝÃD (Ãþ«¬Âà´«¿ù»~)
¦]¦¹µL·N¶¡µo²{ ³o¨Çµo¥Í¿ù»~ªºÀx¦s®æ ¬Ý¤£¨ì¤º®e¡A¨Ï¥Î Len() ¤]¬Ý¤£¨ì¦r¤¸¼Æ¡A
¦ý¨Ï¥Î Value() ¨ç¼Æ«h·| ¶Ç¦^¿ù»~ªº­È¡A¦p¤U¹Ï©Ò¥Ü¡A
½Ð°Ý ³o­ÓÀx¦s®æ¦¡µo¥Í¬Æ»ò¨Æ¤F¡H
§Ú¦³¸Õ¹L¡A¥u­n±N¸ÓÀx¦s®æ Delete¡A¸Ó°ÝÃD´N¥i¸Ñ¨M¡A¦ý¬O¦]¬°¤£ª¾¹D­ì¦]¡A
°ÝÃDÁÙ¬O·|«ùÄòµo¥Í¡A¦Ñ¬O¨Ï¥Î¤H¤u³v¤@ Delete ¤]¤£¬O¿ìªk¡A¦]¦¹·Q½Ð±Ð ¥ý¶i¡A
´Á±æ¨ó§U¸Ñ´b¡AÁÂÁÂ

¸ê®ÆÃþ«¬°ÝÃD.JPG (13.14 KB)

¸ê®ÆÃþ«¬°ÝÃD.JPG

Book2.rar (3.6 KB)

¦^´_ 1# jsleee
Microsoft Office Excel µLªk±N¤å¦rÂà´«¦¨¥¿½Tªº¸ê®ÆÃþ«¬¡C½Ð½T©w¹ï©ó¥²­nªº¹Bºâ¤¸©Î¤Þ¼Æ¦Ó¨¥¡A¤½¦¡©Î¨ç¼Æ¬O¥¿½Tªº¡A¦Ó¥B¤½¦¡©Ò°Ñ·ÓªºÀx¦s®æ¤¤¥]§t¦³®Äªº­È¡C¨Ò¦p¡A¦pªGÀx¦s®æ A5 ¥]§t¼Æ¦r¡A¦ÓÀx¦s®æ A6 ¥]§t¤å¦r¡u¤£¾A¥Î¡v¡A«h¤½¦¡ =A5+A6 ·|¶Ç¦^¿ù»~ #VALUE!¡C

¦pªG¤£·Q¬Ý¨ì¿ù»~°T®§¡A¥i¥H§Q¥ÎIFERROR(2007¥H¤W¤~¦³)¡A¥h±¼¿ù»~°T®§!

=IFERROR((VALUE(A1)),"0")

TOP

¦^´_ 2# ´Ñ»y³¾»ï

¤£¦n·N«ä¡A¤£¤ÓÀ´±zªº·N«ä¡I
§Ú¥D­nªº°ÝÃD¬O·Q­nÁקK ÂŦâ¤Ï¥ÕÀx¦s®æ©Ò¥X²{ªº°ÝÃD¡A
©ÎªÌ¬O¦³¬Æ»ò¤è¦¡¥i¥H³z¹L¨ç¼Æ±N¸Ó¸ê®Æ®æ¦¡°ÝÃDÂà´«±¼¡H
¤£ºÞ¦p¦ó¡AÁÙ¬OÁÂÁ±z.....

TOP

¦^´_ 1# jsleee

­Y¥u¬O³æ¯Âªº·Q§ï¦¨value(a1), «Øij¥i§ï¥În(a1) ©Î§Q¥Î¸ê®Æ­åªR¦p¤U¹Ï:
    tt1.gif

TOP

¦^´_ 4# infoverdad

ÁÂÁ infoverdad ªº¦^ÂСA¾Ç¨ì¤F N() ³o­Ó¨ç¼Æ

TOP

¦^´_ 5# jsleee


    ³o­Ó¬O¦b³o­Ó½×¾Â¤¤©Ò¾Ç²ß¨ìªº®@! ©Ò¥H§Ú­Ì­n¦n¦n¬Ã±¤³o¶ôÄ_¦a!

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD