Tekan F1, lalu ketik "limitation" Berikut sebagian infonya: Feature Maximum limit Number precision 15 digits Largest number allowed to be typed into a cell 9.99999999999999E307 Largest allowed positive number 1.79769313486231E308 Smallest allowed negative number -2.2250738585072E-308 Smallest allowed positive number 2.229E-308 Largest allowed negative number -1E-307 Length of formula contents 1,024 characters Iterations 32,767 Worksheet arrays Limited by available memory. Also, arrays cannot refer to entire columns. For example, an array cannot refer to the entire column C:C or to the range C1:C65536. However, an array can refer to the range C1:D65535 because the range is one row short of the maximum worksheet size and does not include the entire C or D column. Selected ranges 2,048 Arguments in a function 30 Nested levels of functions 7 Number of available worksheet functions 329 Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used) Latest date allowed for calculation December 31, 9999 Largest amount of time that can be entered 9999:59:59
On 5/2/06, rinalvi <[EMAIL PROTECTED]> wrote: > > Dear all > > Hari ini saya makai excell ...waktu > ngetik angka lebih dari 15 digit seperti berikut ini > 123,123,123,123,123,123,123 > maka otomatis excell merubah digit ke 16 dst menjadi 000 seperti berikut > 123,123,123,123,123,000,000 > > Kenapa hal ini terjadi ya ..? apakah ini termasuk bug dari Ms Excell > Soyry nih pertanyaanya mendasar banget .. > Terima kasih atas bantuannya .. > > Salam > /rinalvi > > > > > > > > > -- > www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia > Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] > :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: > ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## > $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ > > [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id > > > Yahoo! Groups Links > > > > > > > [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Info, Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] :: Hapus bagian yang tidak perlu (footer, dst) saat reply! :: ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## $$ Iklan/promosi : www.itcenter.or.id/sponsorship $$ [@@] Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
