Strange excel question

M

mckay

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
 
B

B. R.Ramachandran

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
 
N

Niek Otten

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