#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Values from website turned into useable number values Erik Todd Excel Worksheet Functions 3 April 28th 06 11:51 PM
is number between values chuckwagon2031 Excel Worksheet Functions 2 April 3rd 06 06:47 AM
is number between values chuckwagon2031 Excel Worksheet Functions 0 March 26th 06 11:43 PM
Number values kleivakat Excel Discussion (Misc queries) 1 February 15th 06 11:24 PM
Number of labels on X-axis one more than number of values on Y-axi Gudrun Charts and Charting in Excel 5 August 26th 05 01:55 PM


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"