Detail Spreadsheets Face The Millennium   Oleh:  Harding, Wayne E. Jenis: Article from Bulletin/Magazine Dalam koleksi: Journal of Accountancy vol. 183 no. 6 (1997), page 41-42. Topik: millenium; spreadsheets face; millennium Ketersediaan Perpustakaan Pusat (Semanggi) Nomor Panggil: JJ85.1 Non-tandon: 1 (dapat dipinjam: 0) Tandon: tidak ada     Lihat Detail Induk Isi artikel Are electronic spreadsheet programs ready for the next millennium ? That depends on the definition of "ready." The two major spreadsheet programs - Microsoft Excel and Lotus 1 - 2 - 3 - certainly are capable of calculating dates beyond December 31, 1999. But for them to do it correctly and avoid the ambiguity created by the Year 2000 (Y2K) problem if dates are entered with two digits rather than all four, users have to understand how each application - and each application version - solves the issue. This article explains what you have to know so that when you want to enter the year 2001, it comes out 2001 and not 1901. If youre willing to make the extra effort and type in all four digits when you enter a year, then the solution is easy : Type 2001 - instead of just 01 - and youll get 2001. But if want to take a shortcut and type only two digits, then you must understand your spreadsheet programs method for translating digits into years. Be aware, too, that any year -formatted data you import from other spreadsheets, accounting software databases or an Internet Web site must be four - digit formatted or you may fall victim to an applications idiosyncratic way of determining in which century to cast a two - digit date. If the imported datas years are in two - digit format and youre not clear how your spreadsheet handles years, youll have to go through the tedious exercise of converting all those fields to four - digit years. If you fail to take that step, then brace yourself for problems, because Excel and Lotus have their own ways of making assumptions about the century in which a two - digit year goes, and those assumptions dont agree with each other - let alone agree with your assumptions. The following information tells you how each spreadsheet program recognizes years. Opini Anda Klik untuk menuliskan opini Anda tentang koleksi ini! Kembali

Copyright © 2006, 2007 Unika Atma Jaya, all rights reserved