Excel - LEN of a Date

Giganews Newsgroups
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) ?

4. Regards.

Replies