Strange excel question
 

This question is more out of curiosity...but its been something that I
have been wondering about for sometime. When formatting a cell for
DATE specific...there are 2 date formats that are the exact same
(14-Mar-01). Both seem to produce the exact same output. Can anybody
tell me why there are 2...and if they are different...what are those
differences?

Thanks!

mark


--
mckay
------------------------------------------------------------------------
mckay's Profile: http://www.excelforum.com/member.php...o&userid=29532
View this thread: http://www.excelforum.com/showthread...hreadid=492294

Strange excel question
 

Hi,

January 1, 2005 will show up as '1-Jan-05' with the first and '01-Jan-05'
with the second.

Regards,
B. R. Ramachandran


"mckay" wrote:


This question is more out of curiosity...but its been something that I
have been wondering about for sometime. When formatting a cell for
DATE specific...there are 2 date formats that are the exact same
(14-Mar-01). Both seem to produce the exact same output. Can anybody
tell me why there are 2...and if they are different...what are those
differences?

Thanks!

mark


--
mckay
------------------------------------------------------------------------
mckay's Profile: http://www.excelforum.com/member.php...o&userid=29532
View this thread: http://www.excelforum.com/showthread...hreadid=492294

Strange excel question
 

Just try wit a 1 digit day and you'll see the difference. MS could have
chosen a better example, though

--
Kind regards,

Niek Otten

"mckay" wrote in
message ...

This question is more out of curiosity...but its been something that I
have been wondering about for sometime. When formatting a cell for
DATE specific...there are 2 date formats that are the exact same
(14-Mar-01). Both seem to produce the exact same output. Can anybody
tell me why there are 2...and if they are different...what are those
differences?

Thanks!

mark


--
mckay
------------------------------------------------------------------------
mckay's Profile:
http://www.excelforum.com/member.php...o&userid=29532
View this thread: http://www.excelforum.com/showthread...hreadid=492294