Posted to microsoft.public.excel.worksheet.functions
|
|
date problem in excel
for years before 2000, exclude 20& on the formula
regards
"Marcelo" escreveu:
Hi,
try to use it
=date(20&right(a1,2),mid(a1,3,2),left(a1,2))
format as date dd-mmm-yy
hth
regards from Brazil
Marcelo
"arindamkol_1978" escreveu:
dear all ,
PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT A
DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEAN
(06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THIS
FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA.
ARINDAM
--
arindamkol_1978
------------------------------------------------------------------------
arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861
View this thread: http://www.excelforum.com/showthread...hreadid=560751
|