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

¤Ñ¤å¼Æ¦r¬Û­¼100000000*100000000¦p¦ó³B²z?

¤Ñ¤å¼Æ¦r¬Û­¼100000000*100000000¦p¦ó³B²z?

A1=100000000*100000000=1E+16
§Ú­nªº¬O A1=10000000000000000
¤]¤£­n³]¦¨¼Æ­È  A1=10000000000000000.00    ³o¼Ë¤]¤£¦æ
½Ð¦U¦ì¤j¤j¤£§[«ü¾É  ÁÂÁÂ
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

¦^´_ 1# lucky12345


Äæ¦ì ¡÷ ·Æ¹«¥kÁä ¡÷ Àx¦s®æ®æ¦¡ ¡÷ ¼Æ­È

123.gif (49.07 KB)

123.gif

§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

¦^´_ 2# »k¥ú°j¯T

ÁÂÁ¤j¤j ¸Ô²Óªº¸Ñ»¡
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¥»©«³Ì«á¥Ñ lucky12345 ©ó 2014-10-8 06:48 ½s¿è

¨Ï¥Î«á¥X²{ ·å²«°ÝÃD   ¦V¤j®a³ø§i
¤£ª¾¦³¸Ñ§_?
¤Ñ¤å¼Æ¦r¬Û­¼  §ï¦¨¼Æ­È®æ¦¡  ¨ÌµM¦³³Ì¤j¼Æ­È­­¨î
A1=100000000*1000000000000123
­¼¼Æ¹F¨ì16¦ì¼Æ¥H¤W  ¦A¿é¤J1¦Ü9¥ô¦ó¼Æ¦r  ³£µ¥©ó0
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 4# lucky12345


¤£©ú¥Õ,§Aªº·N«ä!?
§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

¥»©«³Ì«á¥Ñ lucky12345 ©ó 2014-10-8 18:12 ½s¿è

¦^´_ 5# »k¥ú°j¯T

A1=100000000*100000000001234567    ¥¿½Tµª®×¬O  10000000000123456700000000
µ²ªG¥X²{ªºµª®×³ºµM¬O  µ¥©ó  10000000000123400000000000
A1=100000000*100000000001234567
¤]´N»¡  ­¼¼Æªº³Ì«á¤T½X  §Ú½T©w¿é¤J­È¬O  567 ¦ý¬O¥¦¤@²vµ¥©ó¹s   ¸Õºâµ²ªG¦p¤U
A1=100000000*100000000001234567    µ¥©ó  10000000000123400000000000  ³o¬O¿ù»~ªºµª®×
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

²³æ»¡..........
¦bA1¿é¤J         =123456789123456789
¨äµ²ªGµ¥©ó      =123456789123456000
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 7# lucky12345


    ­«ÂI¡GµL¸Ñ


¥Î¨Ó­pºâ¡A¤]´N¬O¦b¼Æ¦r®æ¦¡ªºÀx¦s®æ¤¤ªº¼Æ¦r¤~·|µo¥Í³o­Ó°ÝÃD¡C
¦b³]©w¬°¤å¦r®æ¦¡ªºÀx¦s®æ¡A±z¥i¥HÁä¤J¦h¹F 32767 ­Ó¦r¤¸¡AExcel ªº¤u§@ªíÅã¥Ü³Ì¦h 1024 ­Ó¦r¤¸¡C

¦]¬°¦Û­q¼Æ¦r®æ¦¡³]­p¦¨¥D­n¨Ï¥Îªº¼Æ¦r¡A±zµLªk«Ø¥ß¦Û­qªº¼Æ¦r®æ¦¡¡A
Àx¦s¶W¹L 15 ­Ó¦ì¼Æ¡C¨Ò¦p¡A±zµLªk¨Ï¥Î¤U¦C®æ¦¡¨ÓÀx¦s 16 ­Ó¦r¤¸ªº«H¥Î¥d ID ¥H¼Æ¦r¡G
####-####-####-####

¦pªG±z¿é¤J¼Æ¦r1111222233334444 ¦bÀx¦s®æ¤¤¨Ï¥Îªº ###-###-###-### ®æ¦¡¡A
Excel ·|Åã¥Ü¦bÀx¦s®æ¤¤ªº1111¦~-2222¦~-3333-4440 ¡C±z¹Á¸ÕÀx¦sªº¹ê»Ú¼Æ¦r¬° 1111222233334444¡A
¤]´N¬O¶W¹L¤F¶W¹L¤@¤d¥ü¡C¦ý¬O¡A¦]¬°³o­Ó¼Æ¦r¬O«Ü¤j¡AExcel ·|±Ë±ó³Ì«á¤@­Ó (³Ì¤£­«­n) ªº¼Æ¦r¡AµM«á¥Î¹s¦b¥¦ªº¦ì¸m¡C

¦pªG±z³]©w¬°¤å¦r®æ¦¡ªºÀx¦s®æ¤¤¿é¤J¼Æ¦r¡A¥H±z¿é¤Jªº§Î¦¡¡A
¦]¬° Excel ¤£·|¹Á¸Õ±N«H¥Î¥d¸¹½XÀx¦s¬°¼Æ¦r¡A¦ý«O¯d¬°¤å¦r¡A¤]·|«O¯d©Ò¦³¦r¤¸¡C
§Ú«Ü²Â,©Ò¥H§Ú«Ü¥Î¤ß
¡@§Ú¾ÇÃÀ¤£ºë,¦ý§Ú´÷¨Dª¾ÃÑ

TOP

¦^´_ 8# »k¥ú°j¯T

ÁÂÁ¤j¤j¸Ô²Óªº¸Ñ»¡.........
¤]´N»¡ Excel  ¤£¯à¸Õºâ¤Ñ¤å¼Æ¦r
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

¦^´_ 9# lucky12345

EXCELªº³W®æ¤Î­­¨î
http://office.microsoft.com/zh-tw/excel-help/HP010073849.aspx

­pºâªº³W®æ»P­­¨î
¯S©Ê        ³Ì¤j­­¨î
¼Æ¦rºë½T«×        15 ¦ì¼Æ
³Ì¤pªº¥i®e³\­t¼Æ        -2.2251E-308
³Ì¤pªº¥i®e³\¥¿¼Æ        2.2251E-308
³Ì¤jªº¥i®e³\¥¿¼Æ        9.99999999999999E+307
³Ì¤jªº¥i®e³\­t¼Æ        -9.99999999999999E+307
¸g¥Ñ¤½¦¡¨ú±oªº³Ì¤j¥i®e³\¥¿¼Æ        1.7976931348623158e+308
¸g¥Ñ¤½¦¡¨ú±oªº³Ì¤j¥i®e³\­t¼Æ        -1.7976931348623158e+308
¤½¦¡¤º®eªºªø«×        8,192 ­Ó¦r¤¸
¤½¦¡ªº¤º³¡ªø«×        16,384 ­Ó¦ì¤¸²Õ

¥i¥H¹Bºâ¦¸¤è¼Æ«Ü¤j(¥i¥H­pºâ¤Ñ¤å¼Æ¦r)¦ý¼Æ¦rºë½T«×¥u¦³«e­±15 ¦ì¼Æ
­Y¬O¦³¯S©w®æ¦¡ªº¶Wªøªº¥[ªk¡A©Î³\¥i¥H¥Î¨ä¥L§Þ¥©¨Ó§¹¦¨¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : Ãø¦æ¯à¦æ¡AÃø±Ë¯à±Ë¡AÃø¬°¯à¬°¡A¤~¯àª@µØ¦Û§Úªº¤H®æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD