ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   number values (https://www.excelbanter.com/excel-discussion-misc-queries/205704-number-values.html)

milgo

number values
 

Sco 1 Excel 2007 treats date values as serial numbers, counting the
number of days since when?

a. January 1, 0000.
b. January 1, 1000.
c. January 1, 1900.
d. January 1, 2000.


Mike H

number values
 
Hi,

c

But in addition it could be 1/1/1904.

have a look here.
http://support.microsoft.com/kb/214330

Mike

"milgo" wrote:


Sco 1 Excel 2007 treats date values as serial numbers, counting the
number of days since when?

a. January 1, 0000.
b. January 1, 1000.
c. January 1, 1900.
d. January 1, 2000.



All times are GMT +1. The time now is 06:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com