|Subject:||Excel - LEN of a Date|
|Posted by:||TKT-Tang (tkt_ta…@hotmail.com)|
|Date:||18 May 2004|
1. Select worksheet cell A1 ; and there, enter a combo of keys : "Ctrl
+ ;". That's showing today's date (2004-05-19) thereof.
2. Enter into cell B1, = LEN(A1) ; it's expected to give 10 ;
neverthelss, the calculated result shows 5.
3. How is it possible to compute the apparent length of a date
(also,there's indeed a plethora of other formats by virtue of MS
doing, you know) ?