Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Date conversion question

On Sun, 21 Feb 2010 14:06:54 -0800, CellShocked
<cellshocked@thecellvalueattheendofthespreadsheet. org wrote:

On Sun, 21 Feb 2010 15:17:54 -0500, Ron Rosenfeld
wrote:

Negative numbers represent dates prior to December 30,
1899."

Would that not correctly be: December 31, 1899?

In VBA, that would be true only if you consider zero to be a negative number.
--ron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Date conversion	SITCFanTN	Excel Programming	11	June 8th 06 11:06 PM
conversion question	Tammi P	Excel Programming	4	May 24th 06 03:23 AM
Another Time Conversion question	Sean Skallerud	Excel Discussion (Misc queries)	1	August 24th 05 05:17 PM
Time Conversion question	Sean Skallerud	Excel Discussion (Misc queries)	4	July 21st 05 08:53 PM
date conversion question	WIlliam Barnes	Excel Programming	4	February 29th 04 06:57 PM

All times are GMT +1. The time now is 02:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us